What's new in Postgres 19
Postgres has never had a great built-in way to shrink a bloated table. VACUUM identifies dead space for reuse, but doesn't return it to the operating system. VACUUM FULL and CLUSTER do, but they lock the table for the whole rewrite. For a decade, operators have been forced to reach for extensions like pg_repack and pg_squeeze. Postgres 19 finally brings that capability into core. Among many, the three most notable changes in Postgres 19 are: REPACK rewrites a bloated table, online JIT disabled
