PostgreSQL 19 Released: Key Features, Changes, and Upgrade Guide
PostgreSQL 19 reached general availability today, arriving about six weeks late and leaner than its beta cycle promised. The release centers on production reliability with standout features like REPACK for non-blocking table repair, in-core query-plan control, and WAIT FOR LSN for read-your-writes replication on standbys. Community leaders credit the delay to the deliberate late reverts of ambitious features, arguing that AI-assisted testing now surfaces bugs faster than they can be fixed. With several defaults shifted, including JIT now disabled and a new default compression scheme, operators should review the migration checklist before upgrading.
PostgreSQL 19 Released: Key Features, Changes, and Upgrade Guide @ Linux Compatible
PostgreSQL 19 Released: Key Features, Changes, and Upgrade Guide
PostgreSQL 19 has been released, focusing on production reliability and introducing notable features such as non-blocking table repair (REPACK), in-core query-plan control, and improved replication consistency. The release was delayed by about six weeks due to the removal of ambitious features and the impact of AI-assisted testing, which accelerated bug detection. Key changes include a shift in several defaults, such as disabling JIT compilation and a new compression scheme, prompting operators to review the migration checklist before upgrading. Overall, the release prioritizes stability and performance enhancements while setting the stage for future features in PostgreSQL 20
