PGConf NYC 2021
who it's for
postgresql DBAs, database developers, devops engineers, site reliability engineers, data engineers, engineering managers
topics
Row Level Security; PostgreSQL 14 features; jsonb performance; PostgreSQL indexing strategies; replication and high availability; PostgreSQL sharding; pgbouncer_wrapper connection pooling; Ora2Pg migration validation; pglog log analysis; query performance tuning; advanced PostgreSQL schema design; SCRAM password authentication
| title | author | length |
|---|---|---|
| Navigate Postgres Cloud Paths: Kubernetes, IaaS, or DbaaS | Marc Linster | 20m |
Enterprises move to cloud for agility and lower lock‑in and one customer reports 52 days to provision now needing hours not weeks. VMs plus Ansible fail NIST… | ||
| Driving the Future of PostgreSQL Adoption | Peter Zaitsev, Umair Shahid | 21m |
Argues that PostgreSQL adoption hinges on three measurable things: balancing relational features with scale, making databases frictionless for application… | ||
| Teaching elephants to fish | Ryan Booz | 20m |
Shows a concrete, SQL‑centric schema‑as‑code workflow that goes from database creation to deployed change using Sqitch, FlywayDB, pyrseas, PostgresCompare and… | ||
| Will Postgres Live Forever? | Bruce Momjian | 46m |
Claims that open source outlives proprietary software with a concrete example: Postgres is resurrected in 1996 and shows steady development over 35 years… | ||
| Row Level Security Explained | Stephen Frost | 47m |
Explains how PostgreSQL implements Row-Level Security: policies become WHERE filters during the query rewrite phase, using separate using and with check… | ||
| A look at the Elephants Trunk: PostgreSQL 14 | Magnus Hagander | 55m |
PostgreSQL 14 ships (released 2021-09-30) with concrete changes: scram-sha-256 default (breaks very old clients), SSL compression removal, and… | ||
| Speaking and Community Involvement for the Introvert | Pat Wright | 34m |
Claims that networking beats one-off technical sessions and that 20 seconds of Courage starts conversations guide the advice here. A concrete example: a single… | ||
| Data Security using Roles, Privileges and Row Level Security | Abbas Butt | 42m |
Lists every PostgreSQL privilege and shows which SQL error each missing grant produces, demonstrates granting connect, usage, select, insert, update, delete… | ||
| PostgreSQL Query Performance Insights | Hamid Quddus Akhtar | 50m |
Explains how to use pg_stat_activity, pg_stat_statements, auto_explain, pgBadger, and pg_stat_monitor to get real signals: pg_stat_statements adds 3–4%… | ||
| How we made PG Fitter, Happier, More Productive | Andrew Atkinson | 46m |
Postgres setup scales by adding RDS Proxy for connection pooling, tuning autovacuum (raise cost_limit, lower cost_delay) and increasing provisioned I/O and… | ||
| Advanced Data Types in PostgreSQL | Andreas Scherbaum | 43m |
Explains ENUMs, Arrays, Composite types, Range types, and how to implement custom types with concrete SQL and C functions. Demonstrates ENUM vs domain behavior… | ||
| NORM: No ORM Framework | Henrietta Dombrovskaya | 43m |
Claims an ORM causes many tiny round trips and replaces it with NORM — No‑ORM Framework that maps application model and database model to a JSON transport… | ||
| A Deep Dive into PostgreSQL Indexing | Ibrar Ahmed | 45m |
Shows concrete results: adding a B‑tree on id drops a 26,162 ms sequential lookup to ~2.56 ms; create index concurrently doubles build time (12s → 23s) but… | ||
| Evolution Of PostgreSQL Replication and High Availability (upto ~ 99.999%) | Stacy Scoggins | 50m |
Claims Postgres‑BDR® can deliver 99.999% availability, supports rolling upgrades, and provides automatic DDL replication while running as an active‑active… | ||
| Understanding of Jsonb Performance | Oleg Bartunov | 54m |
Benchmarks show Jsonb cost depends on size, nesting and storage layout not just “it's JSON”; tests across 1 to 1,000,000 rows and concurrent writers reveal… | ||
| Postgres and Json - How to get the best of them? | Charly Batista | 48m |
Postgres with JSONB outperforms plain JSON on reads — tests show typical select speedups of around 3× and in some cases 10–15× using GIN indexes; writes and… | ||
| Migration validation made easy with Ora2Pg | Gilles Darold | 54m |
Ora2Pg celebrates 20 years and now includes concrete validation: a test action that compares schema and row counts, and a data validation mode that pulls rows… | ||
| Managing PostgreSQL changes for the Agile DBA | Ryan Booz | 52m |
Experience managing thousands of tenant databases leads to concrete tradeoffs: Sqitch gives deploy/verify/revert SQL-centric steps, FlywayDB adds repeatable… | ||
| War Stories: Fighting the PostreSQL Support Trenches | Hans Jurgen | 34m |
Twenty years of PostreSQL support yields concrete failures and fixes: flying to Kiribati for a live system, getting held two and a half hours at United Nations… | ||
| How to improve PostgreSQL Monitoring and ... | Agustin Gallego, Charly Batista | 51m |
Percona Monitoring and Management (PMM) is shown working end to end: metrics and dashboards pull Postgres stats, OS counters and query samples, alerts fire… | ||
| Typo Positive: When Collection Doesn't Get You What You Need | Renee Phillips | 39m |
Claims that collection choices, not topic labels, break data: sensors show condensation and calibration cause pressure drift, GPS fails in urban canyons so… | ||
| Understanding and Reducing Application Contention | Simon Riggs | 48m |
Explains what lock waits, deadlocks and serialization errors are, how to detect them with PG stat activity and pg_locks and by enabling log_lock_waits, and why… | ||
| When it all GOes right | Pavlo Golub | 49m |
Covers concrete Go + PostgreSQL choices: prefer pgx over lib/pq with reasons — binary formats, native COPY and LISTEN/NOTIFY, prepared statement caching — and… | ||
| When it All Goes Wrong: Database Incident Response Dos and Don'ts | Christopher Travers | 38m |
A production Postgres cluster hits an impending transaction ID wraparound after a background vacuum stalled eight days, leaving about three hours to shutdown… | ||
| So You Inherited A Database | Corey Huinker | 54m |
Claims concrete steps to survive an inherited database: verify and test backups and SLAs, map inputs and consumers, build a data dictionary and push… | ||
| NORM: No ORM Framework | Henrietta Dombrovskaya | 36m |
A Postgres-centered toolset compares live catalogs across environments using foreign data wrappers to import catalogs and run fast diffs, not repository text… | ||
| Do it in SQL: pgbouncer_wrapper | David Fetter | 42m |
pgbouncer_wrapper lets you control pgbouncer with SQL by exposing one view per SHOW command and one function per control command, running as a lightweight… | ||
| Chasing unicorns : 0 dataloss and 99.999% availability | Laetitia Avrot | 45m |
Explains why mathematical zero data loss and 100% uptime are impossible and shows concrete tradeoffs: CAP and PACELC constraints, five nines (≈5 minutes/year)… | ||
| Identifying Slow Queries and Fixing Them! | Stephen Frost | 47m |
PostgreSQL logging and stats expose concrete fixes: enable log_min_duration_statement (zero logs every statement, or use log_min_duration_sample with a sample… | ||
| Advanced Postgres Schema Design (For Scalable Application Development) bySehrope Sarkuni | Sehrope Sarkuni | 48m |
Postgres-specific features replace clever app hacks with concrete guarantees: using the native uuid type shrinks indexes and prevents bad IDs, a date-range… | ||
| How PostgreSQL aggregates work and how to create and use custom... | David Kohn | 33m |
Explains how PostgreSQL aggregates maintain state with transition, combine, and final functions, how parallel aggregation and serialization work, and why… | ||
| Flexible Indexing with Postgres | Bruce Momjian | 49m |
Indexes beyond btree actually change performance: BRIN (block range) is tiny and suits chronologically ordered huge tables, Postgres 14 adds multi-range BRIN… | ||
| Advanced Int - Bigint Conversions | Robert Treat | 42m |
Claims an actual near-miss outage at a unicorn and gives concrete fixes: a cheap pg_stats histogram query to find columns approaching 2,147,483,647, an… | ||
| Pglog: a flexible log analyser | Laetitia Avrot | 34m |
Shows how to import CSV-format PostgreSQL logs into a local Postgres instance, using Postgres on laptop and a file_fdw/materialized views option; ships ready… | ||
| PostgreSQL sharding, state of the art | Julien Tachoires | 34m |
Postgres relies on postgres_fdw plus declarative partitioning for built‑in sharding, with concrete features added over versions: FDW since 9.3, aggregate… | ||
| Get Your Insecure PostgreSQL Passwords to SCRAM! | Jonathan S. Katz | 55m |
Shows why PostgreSQL passwords must move to SCRAM and demonstrates the actual upgrade steps and failures avoided: building a SCRAM verifier with a 16 byte… | ||
| nothing matches | ||