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.