PostgreSQL 17 and beyond
summary
PostgreSQL 17 adds incremental backups via a new background worker that records changed blocks (restored with pg_combine), vacuum improvements using a TID store and combined freeze/prune to cut WAL and avoid repeated passes, and new streaming APIs for faster sequential scans. Logical replication gains failover slots that sync slots to a standby and slot retention across major upgrades (17→18 only), plus a 30x decoding speedup for transactions with many subtransactions and pg_create_subscriber to initialize from a standby.
AI-written summary · about
chapters (9)
- 0:00Evolution of Postgres
- 6:04Introduction to Postgres 17
- 6:21Performance enhancements
- 14:44Logical replication updates
- 22:41SQL and partitioning features
- 29:55Merge command and security
- 33:40JSON and monitoring tools
- 35:26Future development roadmap
- 38:50Q&A and closing remarks
related talks
46mPostgreSQL 16 and beyond
49mIncremental Backup
53mThe journey towards active replication in PostgreSQL
01h 41mPostgreSQL Upgrades with Logical Replication & Minimal Downtime
49mBeyond PostgreSQL 17
37mFailover Slots in PostgreSQL-17:
44mThe journey towards active-active replication in PostgreSQL
31mPast, Present, and Future: Logical Decoding and Replication in PostgreSQL