PGConf NYC 2022
| title | author | length |
|---|---|---|
| Opening & Welcome | Pat Wright | 07m |
Brief logistical run-through: schedule is available via QR codes, four session rooms line the wall and a quiet room behind registration is open; breakfast… | ||
| Future Postgres Challenges | Bruce Momjian | 23m |
Postgres claims 35+ years of development, ~26 years of annual releases and ~170–190 features per release, but risks lurk: governance concentration can produce… | ||
| Building a better PostgreSQL together | Jonathan S. Katz | 14m |
Overview of concrete changes and roadmaps: announces Amazon RDS Multi-AZ with two readable standbys, claiming 2× faster commit latency and failovers typically… | ||
| Benchmarking your commits: The Postgres Performance Farm | Ilaria Battiston | 44m |
A benchmarking pipeline that automatically clones and builds Postgres, runs pgbench and TPC-H, uploads results to a web server and links each result to the… | ||
| PostgreSQL and DevSecOps Ensuring database security in DevSecOps | Tim Steward | 40m |
Pipeline makes Jenkins the central CI/CD hub and enforces database schema versioning alongside app releases; secrets use HashiCorp Vault key store or HSMs… | ||
| Securing PostgreSQL From External Attack | Bruce Momjian | 50m |
Explains why md5 4‑byte salt is insecure (birthday-style collisions ~16k–32k tries), why Postgres moves to SCRAM+channel binding (Postgres 10 and channel… | ||
| How to create an hacking toolkit thanks to the pageinspect ... | Bertrand Drouvot | 42m |
Shell scripts (no C) use pageinspect plus dd and od to read page checksum and extract how many tuples are on a page, and pull tuple header fields like xmin… | ||
| PostgreSQL worst practices | Ilya Kosmodemiansky | 36m |
Advocates a shuffled deck of over 100 concrete misconfigurations, sampling ~10 per session with a small script, and illustrates damage with reproducible… | ||
| Optimal Data Loads | Ben Lis | 48m |
A 295 MB CSV of ~2 million rows and 10 fields loads row-by-row in ~9:15 locally and ~7:11 over the network, but switching to COPY/backslash COPY via psycopg… | ||
| Understanding Transaction Isolation for App Developers | Chandra Sekhar Pathivada | 28m |
Explains PostgreSQL MVCC so writers never block readers and details three concrete anomalies with numbers: IMAX price $10 plus $5 twice becomes $20 (lost… | ||
| Do we really need a DBA to manage our PostgreSQL databases on DBaaS | Avi Vallarapu | 34m |
Argues that DBaaS defaults are generic and often harmful: vendors set max_connections=16000+ to avoid support tickets, autotuning ignores workload patterns… | ||
| How to Contribute to an Open Source Project like Postgres? | Claire Giordano | 43m |
Covers 13 contribution paths with concrete entry points: join PG mailing lists (PG‑SQL‑hackers, PG‑SQL‑docs), file bugs via the web form or… | ||
| The I in ACID | Lætitia Avrot | 38m |
Clear definitions of ACID with focus on isolation anomalies: dirty read, lost update, non‑repeatable read and phantom read, each shown with concrete bank or… | ||
| PostgreSQL Replication Conflicts: Avoiding Pitfalls | Hamid Quddus Akhtar | 42m |
Demo uses PostgreSQL 14.1 on CentOS 7 with a single primary and standby and shows two reproducible failures: a lock conflict when a standby transaction touches… | ||
| Why PostgreSQL is becoming the standard in Financial Services | Shayon Sanyal | 46m |
PostgreSQL wins in Financial Services by cutting licensing cost and proving it handles mission‑critical, low‑latency OLTP: example credit‑card flows store… | ||
| Data Portals: Using PostgreSQL server-side cursors for secure and ... | Brian Hodge | 48m |
Uses PostgreSQL named server-side cursors (psycopg2 NamedCursor) to hand a preloaded query resultset between apps, plus short-lived Postgres user accounts and… | ||
| The SQL standard: Where does it come from? Where does it go? | Peter Eisentraut | 51m |
Participation requires join via national body (ANSI, DIN etc), monthly Zoom WG3 meetings and uploading a paper to the content system; SQL reaches DIS ballot… | ||
| Sharding PostgreSQL using Foreign Data Wrappers | Krishna Sarabu | 52m |
Shows how to shard PostgreSQL using postgres_fdw and declarative partitioning, with concrete features and limits: join/aggregate/order-by pushdown… | ||
| The Future of Observability in Postgres | Greg Stark | 53m |
Current Postgres monitoring uses external postgres_exporter processes that connect over SQL to PG stats views, causing operational complexity, connection… | ||
| PostgreSQL vs The Standard | Vik Fearing | 49m |
Compares concrete SQL Standard rules with PostgreSQL behavior: Standard orders triggers by creation timestamp (immutable) and Postgres follows that; Standard… | ||
| Hacking on Postgres: An Overview | James Coleman | 50m |
Step‑by‑step roadmap for getting code into Postgres: use the mailing list & commitfests workflow, attach discussion threads in the CF app, and expect long… | ||
| How to Tame A Mastodon: Lessons for PostgreSQL at Scale | David Christensen | 48m |
Describes running a 25TB OLTP PostgreSQL cluster with 15 replicas, 150GB/hr WAL and ~230M transactions/hr and the concrete fixes used: switch to PGBackRest… | ||
| The MERGE Command | Simon Riggs | 46m |
Postgres 15 adds a working MERGE that applies INSERT/UPDATE/DELETE from a source to a target per the SQL standard; it decides match status once (so concurrency… | ||
| A Deep Dive into PostgreSQL Indexing | Ibrar Ahmed | 52m |
Explains when an index actually speeds queries and when it hurts, shows using pg_stat_statements to find candidates, and contrasts index types with concrete… | ||
| 3+ Features Developers Use That Might Never Make It to PostgreSQL | Denis Magda | 49m |
Application developers want to run language-native functions directly on database nodes to avoid packaging, copying and redeploy cycles: demo compiles a Java… | ||
| The Elephantine Upgrade | Julien Riou | 50m |
OVHcloud migrates 230 databases across 50+ clusters from PostgreSQL 9.6 to 14 using Ansible + AWX to orchestrate automated playbooks and a one-click promotion… | ||
| NORM_GEN: an alternative to ORM | Henrietta Dombrovskaya, Boris Novikov | 42m |
NORM-GEN generates PostgreSQL user-defined types and stored functions from an annotated JSON schema, producing bulk transfer objects that convert to JSON on… | ||
| Exacting Standards: Considerations for Precision and Accuracy ... | Renee Huinker | 46m |
Covers concrete rules and failures: prefer Postgres numeric over double precision for exact math, avoid the built-in money type for currency, and use PostGIS… | ||
| Database Disasters and How to Find Them | Christophe Pettus | 51m |
Checklist-driven incident response: confirm connectivity, check logs and I/O, and fail over if the instance is truly down. Gives concrete fixes from real… | ||
| Postgres for the SQL Server DBA | Pat Wright | 46m |
Practical checklist for SQL Server DBAs moving to Postgres: connection uses port 5432 and username/password (no Windows auth); GUIs recommended — DataGrip… | ||
| What I learned about the PostgreSQL Community | Andreas Scherbaum | 32m |
Weekly interviews collect concrete community data: 214 interviews started, 134 completed and published, 106 by September 2021 and 426 names in the pool… | ||
| Understanding PostgreSQL Query Plans (aka EXPLAIN) | Stephen Frost | 52m |
Shows how to read EXPLAIN and EXPLAIN ANALYZE outputs, what EXPLAIN ANALYZE with buffers and io timing reveals about shared hits versus OS reads, and how… | ||
| Top Takeaways from the 2022 State of PostgreSQL Survey | Ryan Booz | 20m |
Survey of almost 1,000 responses shows more than 50% of respondents in EMEA, a rising share with 10+ years of Postgres experience, and nearly 80% use Postgres… | ||
| A look at the Elephants Trunk - PostgreSQL 15 | Magnus Hagander | 52m |
PostgreSQL 15 is at release-candidate stage with five commit fests behind it and a release expected within weeks; key changes include dropping PL/Python2… | ||
| Closing | Pat Wright | 08m |
Conference closes with sponsors thanked and organizers and volunteers acknowledged for unpaid hours, plus praise for the friendly community and events… | ||
| nothing matches | ||