Opening - Welcome to PGConf.NYC 2024!

Mon. 09:30–09:50 — The Forum

Keynote: Growing the PostgreSQL Community with PgUS

Mon. 09:45–10:10 — The Forum

Sponsor Keynote: Everything Postgres at Microsoft – 2024 in Review

Mon. 10:10–10:30 — The Forum

Charles Feddersen

What's new in PostgreSQL 16

Mon. 11:00–11:50 — The Forum

Magnus Hagander 

Beginner's Guide to Partitioning vs. Sharding in Postgres

Mon. 11:00–11:50 — Club Parlor

Claire Giordano 

Reducing Costs and Improving Performance With Data Modeling in Postgres

Mon. 11:00–11:50 — The Hub

Charly Batista

Transparent Application-level Encryption with Postgres Trusted Language Extensions

Mon. 11:00–11:50 — Library (Sponsor)

Billy VanCannon

Lesson learned from auto-tuning PostgreSQL

Mon. 12:00–12:50 — The Forum

Costa Alexoglou 

Human Beings Do Not Have a Primary Key

Mon. 12:00–12:50 — Club Parlor

Christophe Pettus 

Extension Development Lifecycle in Rust

Mon. 12:00–12:50 — The Hub

Arda Aytekin 

Amazon Aurora High Availability and Disaster Recovery Features for Global Resilience

Mon. 12:00–12:50 — Library (Sponsor)

Shayon Sanyal 

Block Party: Notion's journey to scaling Postgres

Mon. 14:00–14:50 — The Forum

Arka Ganguli 

Importance of PostgreSQL Vacuum Tuning to Optimize Database Performance

Mon. 14:00–14:50 — Club Parlor

Suyog Sampat Pagare

Looking for the differences in your data

Mon. 14:00–14:50 — The Hub

Tatiana Krupenya 

Advantages of globally distributed PostgreSQL in a managed cloud for ultra-high availability, disaster tolerance and greater security

Mon. 14:00–14:50 — Library (Sponsor)

Surpassing 100K Postgres Connections With An In-Database Connection Pooling Extension

Mon. 15:00–15:50 — The Forum

Jonah H. Harris 

Overcoming Migration Challenges: From Oracle to PostgreSQL

Mon. 15:00–15:50 — Club Parlor

BAJI SHAIK, Sameer Malik

Postgres schema migrations using the expand/contract pattern

Mon. 15:00–15:50 — The Hub

Andrew Farries

ODAK - Cloud-Native Postgres Appliance

Mon. 15:00–15:50 — Library (Sponsor)

Onur Eroğlu

JSON performance in Postgres and indexes.

Mon. 16:30–17:20 — The Forum

Gleb Otochkin 

Terraforming Postgres

Mon. 16:30–17:20 — Club Parlor

Selena Flannery

Incremental Backup

Mon. 16:30–17:20 — The Hub

Robert Haas 

Is Application Refactoring Holding Back Your Oracle to PostgreSQL Migrations? Datavail Introduces Intelligent Database Virtualization from Liberatii

Mon. 16:30–17:20 — Library (Sponsor)

Eric Russo , James Reynolds, Nima Torabi 

Sponsor Keynote: Our ongoing journey enhancing PostgreSQL

Tue. 09:50–10:10 — The Forum

David Rader 

Latest developments in PostgreSQL

Tue. 10:40–11:30 — The Forum

Amit Kapila 

Indexing Beyond Columns: Expressions, Text Fragments, JSON Attributes, and Top-N Queries

Tue. 10:40–11:30 — Club Parlor

Franck Pachot 

Securing Postgres for use with GenAI

Tue. 10:40–11:30 — The Hub

Min-Hank Ho

PostgreSQL operational pain points and solutions

Tue. 10:40–11:30 — Library (Sponsor)

Monica Sarbu , Tudor Golubenco 

Postgres Platform "Best Practices" for the Modern DBA

Tue. 11:40–12:30 — The Forum

Chelsea Dole

Time Travel Queries with Postgres

Tue. 11:40–12:30 — Club Parlor

Qian Li 

Testing your PostgreSQL backups: a practical guide

Tue. 11:40–12:30 — The Hub

Nicholas Meyer

Where does it hurt? Gathering information to help us help you

Tue. 11:40–12:30 — Library (Sponsor)

Christophe Pettus 

Best practices for using pgvector

Tue. 14:00–14:50 — The Forum

Jonathan S. Katz 

Unlocking the Postgres Lock Manager

Tue. 14:00–14:50 — Club Parlor

Bruce Momjian

Discovering Postgres: A Journey into the #1 Open Source Relational Database

Tue. 14:00–14:50 — The Hub

Emma Saroyan

Postgres on Azure - a whirlwind tour of Flexible Server

Tue. 14:00–14:50 — Library (Sponsor)

Guy Bowerman , Kanchan Bharati 

Mastering PostgreSQL Partitioning: Supercharge Performance and Simplify Maintenance

Tue. 15:00–15:50 — The Forum

Ryan Booz 

Postgres Security Primer: Considering Multiple Perspectives

Tue. 15:00–15:50 — Club Parlor

Elizabeth Christensen 

Real-time Predictions with PostgreSQL and PL/Python

Tue. 15:00–15:50 — The Hub

Drishti Jain 

Beyond PostgreSQL 17: 7 DBA Workarounds for Enhanced Management

Tue. 15:00–15:50 — Library (Sponsor)

Vibhor Kumar

Sponsor Keynote: Havelsan

Wed. 09:50–10:10 — The Forum

N. Semih Demirtoka

Scaling past RDS PostgreSQL's vertical scaling limits: Lessons and guidance on the largest PostgreSQL workloads

Wed. 10:40–11:30 — The Forum

Alisdair Owens , Andrei Dukhounik 

Elastic-Quality full-text search in Postgres via Tantivy

Wed. 10:40–11:30 — Club Parlor

Philippe Noël 

Making the best use of modern SSL

Wed. 10:40–11:30 — The Hub

Peter Eisentraut 

A look at key tradeoffs in gen AI development on PostgreSQL

Wed. 10:40–11:30 — Library (Sponsor)

Sandy Ghai, Shane Borden 

Advancing Drug Search with PostgreSQL

Wed. 11:40–12:30 — The Forum

Taras Kloba

9.2 to 15 and beyond: a case study of a tricky upgrade path

Wed. 11:40–12:30 — Club Parlor

Nicholas Meyer

The PostgreSQL License Fee: Community Participation

Wed. 11:40–12:30 — The Hub

Stacey Haysler

Automated Database Change Management with Flyway and CI/CD Pipelines

Wed. 11:40–12:30 — Library (Sponsor)

Ryan Booz 

Using Logical Replication for Major Version Upgrades and Tenant Migrations

Wed. 14:00–14:50 — The Forum

Shayon Mukherjee 

Becoming a PG_STAT_* (star)

Wed. 14:00–14:50 — Club Parlor

Chirag Dave, Sami Imseih

How to: Never be on call as a DBA Again

Wed. 14:00–14:50 — The Hub

Pat Wright 

How to optimize a slow Postgres query, featuring pganalyze

Wed. 14:00–14:50 — Library (Sponsor)

Lukas Fittl 

A journey into postgresql logical replication: the next chapter

Wed. 15:00–15:50 — The Forum

José Neves 

Greenplum is no longer OSS: change of operations in mid-flight

Wed. 15:00–15:50 — Club Parlor

Joaquim Oliveira , Pilar de Teodoro 

pg_hint_plan - get the right plan without surprises

Wed. 15:00–15:50 — The Hub

Franck Pachot 

No Time To Rest – A Developer’s TDE Journey

Wed. 15:00–15:50 — Library (Sponsor)

Muhammad Usama