PostgreSQL 19 features I'm excited about
3 hours ago
- #PostgreSQL 19
- #Database Features
- #Performance Optimization
- PostgreSQL 19 introduces pg_plan_advice and pg_stash_advice for in-core plan stability, allowing persisted plan advice to fix planner regressions without application changes.
- DDL extraction functions (pg_get_database_ddl, pg_get_role_ddl, pg_get_tablespace_ddl) provide stable, in-core methods to retrieve CREATE statements, replacing bespoke extractors.
- Online maintenance features include REPACK CONCURRENTLY for lock-free table reorganization and online data checksum toggling, eliminating maintenance windows.
- New observability views: pg_stat_lock for lock contention history and pg_stat_recovery for atomic snapshot of standby recovery state, enhancing diagnostics.
- Logical replication now supports sequence synchronization via REFRESH SEQUENCES, making zero-downtime upgrades and failover safer.
- MultiXact member ceiling is eliminated by widening to 64 bits, removing the risk of emergency vacuums due to member exhaustion.
- Autovacuum improvements include parallel workers (autovacuum_max_parallel_workers), priority visibility via pg_stat_autovacuum_scores, and enhanced logging for better tuning.