PostgreSQL 19 Released with Online Table Repacking and Query Planning Controls

The PostgreSQL Global Development Group released PostgreSQL 19, introducing changes to database maintenance, query planning, replication, and application development. The release focuses on reducing administrative overhead and improving performance, with new tools for reorganizing tables without downtime and controlling query plans. One of the main additions is REPACK, which reclaims unused table space and can reorder data to match an index.
Its CONCURRENTLY option allows the operation to run without blocking reads or writes, making it a potential replacement for common uses of VACUUM FULL and CLUSTER. PostgreSQL 19 also introduces pg_plan_advice and pg_stash_advice, extensions that let administrators influence query plan selection and apply stored advice to queries by identifier, without changing application code.
Excerpt from InfoQ, in their own words. Bonzai did not write this story; the full version is on the publisher’s site.