Radim Marek: What REPACK (CONCURRENTLY) costs while it runs

Two years ago I compared pg_repack and pg_squeeze, the two extensions most of us reach for when a table has bloated beyond what autovacuum will ever give back and VACUUM FULL isn't an option. PostgreSQL 19 changes the starting point. REPACK brings VACUUM FULL and CLUSTER together under one command…

cloud

Sources