Looking Ahead to Postgres 19
2 hours ago
- #Database Updates
- #Postgres 19
- #Performance Improvements
- Postgres 19 is a diverse release with improvements across multiple areas.
- Introduces REPACK CONCURRENTLY for concurrent table repacking without locks.
- Adds partition merging and splitting for flexible partition management.
- Enhances logical replication with sequence synchronization and EXCEPT clause.
- Improves autovacuum with parallel workers, scoring system, and better visibility.
- Adds SQL/PGQ for property graph queries within relational data.
- Expands COPY functionality with JSON output and error handling options.
- Includes SQL quality-of-life improvements like GROUP BY ALL and IGNORE NULLS.
- Delivers performance enhancements in planner, executor, and sort operations.
- Overall, Postgres 19 broadens capabilities for developers, operators, and performance tuning.