A detailed personal recap of PGConf.dev 2026 in Vancouver, covering key sessions across four days. Highlights include discussions on PostgreSQL logical replication roadmap gaps (DDL replication, failover), global index challenges for partitioned tables, the upcoming REPACK CONCURRENTLY feature for PostgreSQL 19, index prefetching progress, pg_plan_advice for query plan stability, TDE design debates, and AI-assisted query optimization research. The conference also celebrated PostgreSQL's 30th anniversary. Unconference sessions tackled global indexes, AI in PostgreSQL development, and logical replication edge cases. CommitFest metrics revealed growing patch volume but declining reviewer capacity and contributor retention.
Table of contents
About PGConf.devTuesday No Longer Feels Like a “Pre-Conference” DayOfficial Opening on WednesdayUpdate on index prefetchingThursday – The Energy of PGConf.dev ContinuesThe Unconference + Closing on FridayClosingConclusion3 Impressions