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.
Need help?
Contact usPostgres 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.