PostgreSQL 19 Beta 2 has been released for testing, featuring native SQL/PGQ graph queries, a unified REPACK command for zero-downtime table reorganization, and several important performance and security enhancements. The release is now in a feature-freeze state, focusing on stability ahead of its planned launch in 2026, with breaking changes in string handling and index operations requiring careful migration planning. Notable improvements include a shift in default TOAST compression to lz4, the disabling of JIT by default, and enhanced autovacuum capabilities, all aimed at optimizing performance. Users should be cautious when migrating to Beta 2 due to various default behavior changes, and it is recommended to avoid using beta versions in production environments while testing typical workloads
PostgreSQL 19 Beta 2 Released: Native Graph Queries, Unified REPACK and Feature Freeze
PostgreSQL 19 Beta 2 is now available for testing, locking down features to focus on stability ahead of its 2026 launch. This release introduces native SQL/PGQ graph queries, a unified REPACK command for zero-downtime table reorganization, and shifted defaults for JIT and TOAST compression. Several breaking changes in string handling, index opclasses, and encoding require careful planning before migration. Database administrators and developers should review the open items list and benchmark their workloads against the new build.
