Cyber ·
PostgreSQL 19 released: REPACK (CONCURRENTLY) and pg_plan_advice
The PostgreSQL Global Development Group announced version 19, with the REPACK (CONCURRENTLY) command, the pg_plan_advice extension and performance improvements. The notice was reproduced from a LWN feed.
The PostgreSQL Global Development Group announced the release of PostgreSQL 19, according to coverage reproduced through an automatic translation of a LWN feed, published on November 19, 2026. Highlighted features include the REPACK (CONCURRENTLY) command, which allows reorganizing tables without interrupting ongoing operations, and the pg_plan_advice extension, aimed at giving more control over execution plan stability and query performance. The source also mentions several performance improvements, without detailing them in the available text.
LWN reported in September the removal of several features that were initially planned for this release, which is worth considering before planning migrations. The complete list of new features and changes is in the project's official release notes, which should be consulted to confirm any technical detail before production use.