PostgreSQL 19 released with REPACK (CONCURRENTLY) and plan advice
The new version adds a command for repacking tables while work continues, plus the pg_plan_advice extension and performance improvements. Several features planned for the release were removed before launch.

Key takeaways
- The PostgreSQL Global Development Group has released PostgreSQL 19, according to LWN.net.
- The REPACK (CONCURRENTLY) command is intended to optimise tables without stopping ongoing operations.
- The pg_plan_advice extension targets query plan stability and query performance.
- Several features originally planned for this release were removed before launch.
In this article
What the release adds
PostgreSQL 19 is out. The PostgreSQL Global Development Group announced the new version, and LWN.net reported it on 19 November 2026.
The release brings a REPACK (CONCURRENTLY) command, a new extension named pg_plan_advice, and several performance improvements. According to LWN, the project's release notes carry the complete list of features and changes.
Repacking tables while work continues

REPACK (CONCURRENTLY) is meant to let database teams reorganise and optimise tables while normal operations carry on. Maintenance of this kind has often needed a pause in activity, so the concurrent form is intended to reduce that disruption.
PostgreSQL is an open source database system that stores and serves data for applications. Many of those applications need to stay available, which is where a concurrent maintenance option matters.
Plan advice and performance work
The pg_plan_advice extension is described as giving administrators more say over how stable query plans stay and how quickly queries run. A query plan is the route a database chooses to find requested data. That route can change as data and settings change, which can affect response times.
The update also includes performance improvements, which LWN does not itemise. In September the site covered the removal of several features that had been expected in this version, so the shipped feature set is narrower than first planned.
Checking the full change list
Teams running PostgreSQL can read the release notes for the full set of changes in version 19. Those notes cover the features that made it into the release, while LWN's September coverage records the ones that were cut.
Sources
- PostgreSQL 19 releasedLWN.net
Spotted a mistake? See our corrections policy. Read how News by OnDevice works in our editorial policy.



