a month ago
- Postgres 19 includes a variety of features across application development, operations, performance, and extensibility.
- REPACK CONCURRENTLY is a built-in command for reclaiming table bloat without locks, improving quality of life for production databases.
- Partitioning enhancements allow merging and splitting partitions, providing flexibility to adapt to changing data workloads.
- Logical replication now supports sequence synchronization, EXCEPT clause for publications, and better configuration with effective_wal_level.
- Autovacuum improvements include parallel workers, a scoring system for prioritization, and enhanced monitoring via new views and logs.
- SQL property graph queries (SQL/PGQ) enable graph-style queries on relational data without requiring a separate database.
- COPY command upgrades include skipping multiple header lines, ON_ERROR SET_NULL option, and JSON output for easier data workflows.
- SQL quality-of-life features include GROUP BY ALL, IGNORE NULLS for window functions, and improved upsert behavior with RETURNING.
- Performance enhancements cover planner optimizations, anti-joins, SIMD usage in COPY, and faster foreign key checks.
- The release emphasizes breadth, making Postgres better for multiple personas and workloads, encouraging testing before GA.