Conference Sessions - PGConf NYC 2025

The following list contains all the talks that have been approved so far for PGConf NYC 2025. Note that they may not yet have been scheduled! You can find the full conference information at the conference website.

Session

• 1 Billion Row Challenge: Comparing Postgres, DuckDB, and Extensions (Ryan Booz)
• 200TB and Rising: A Real-World Upgrade Story from the Trenches of PostgreSQL (Vibhor Kumar)
• AIO in PG 18 and beyond (Andres Freund)
• A look at the Elephant's trunk - PostgreSQL 18 (Magnus Hagander)
• Becoming a PG_STAT_*STAR [Returns] (Chirag Dave)
• Best practices for Ephemeral Environments with PII for Postgres (Monica Sarbu)
• Beyond monitoring: How we built an open-source, self-healing Postgres agent (Alex Francoeur)
• Check Your Privileges: The PostgreSQL Role System (Christophe Pettus)
• Database modeling to study the New York Jazz scene (Boriss Mejias)
• Data Sovereignty with PostgreSQL (Tim Steward)
• Decoding Climate Science with Open Data Resources: What AI's Energy Needs Mean for Our Planet (bonny p mcclain)
• Extension Development - Lessons From Partitioning and Monitoring (Keith Fiske)
• How (and why) Datadog is moving from cloud-managed to self-managed Postgres (Nick Canzoneri)
• Hybrid Search on Postgres at Scale (Ankit Mittal)
• Identity at Scale - How Auth0 Uses Postgres (Norberto Leite)
• Improved Freezing in Postgres Vacuum: From Idea to Commit (Melanie Plageman)
• Kubernetes from the Database Out (Alastair Turner)
• Making HTAP a reality with Postgres (Zhou Sun)
• Mastering Time-Series Data in PostgreSQL: advanced partitioning strategies and BRIN indexes (Block Range INdexes) to speed up the ingestion (Domenico di Salvia)
• Modern Role and Authentication Management Through a Custom Proxy (Jonathan Hinds)
• Multitenancy Patterns in Community PostgreSQL (Andrew Atkinson)
• Optimizing for access patterns: Postgres Table Access Methods and Index Access Methods (Tom Kincaid)
• Optimizing PostgreSQL with Table Partitioning: Scaling Alternative Data at Bloomberg (Ivan Sayapin, Yu Lung Law)
• Overcoming Challenges in SQL Server to PostgreSQL Migrations: Mapping Backups, Collations, and Case Sensitivity (SAMEER KUMAR)
• PgBouncer in Parallel: Bringing Multithreading to the Trusted Postgres Pooler (Beihao Zhou, Guanqun Yang)
• pg_duckdb: Ducking awesome analytics in Postgres (Jelte Fennema-Nio)
• PostgreSQL Disaster Recovery at Scale: Lessons from Amazon RDS Operations (Andrei Dukhounik)
• Practical Guide to Migrating +100 Large PostgreSQL to the Cloud (Nelson Calero)
• Practical PgBouncer Pain Prevention (Nicholas Meyer)
• Running AlloyDB Omni Postgres - On-premises or in your cloud (Simon Pane)
• Scaling Postgres at Semgrep: How We Cut p99 Latency From Minutes to Under 7 Seconds (Pang Nganthavee)
• Scaling Postgres to the next level at OpenAI (Bohan Zhang)
• Secure Your PostgreSQL Credentials with HashiCorp Vault (Dwarka Rao)
• Ten Postgres Hacker Journeys—and what they teach us (Claire Giordano)
• The 5 levels of using JSON_TABLES (Jay Miller)
• Transforming Data with the Power of PostgreSQL and SQL (Ryan Booz)
• Unlocking Astronomical Breakthroughs: Postgres Sharding Strategies for Continuous Discovery (Joaquim Oliveira, Pilar de Teodoro)
• Unlocking New Possibilities: The Evolving Landscape of PostgreSQL Logical Replication (Amit Kapila)
• Unlocking PostgreSQL Performance: A Guide to Index Types and When They Should Be Used (Shane Borden)
• Unlock PostgreSQL’s True Performance with Local SSDs (Burak Yucesoy)
• Vacuuming Large Tables: How Recent Postgres Changes Further Enable Mission Critical Workloads (Robert Treat)
• Vector data in Postgres: Size, TOAST, Filters and Performance (Gleb Otochkin)
• When Logical Replication Goes Wrong (Robert Bernier)
• Workload fingerprints: A key to understanding PostgreSQL performance (Luigi Nardi)