
Tech
PostgreSQL 19 REPACK: Removing Table Bloat Online
PostgreSQL 19 REPACK is a native command that unifies VACUUM FULL and CLUSTER and adds a CONCURRENTLY option, so you no longer have to choose between reclaiming disk space and keeping a table online. After a large delete or an update-heavy workload, a table can bloat, and autovacuum can't return that space to the operating system. DBAs have had two poor choices: VACUUM FULL, which locks the table for the whole rewrite, or the third-party pg_repack extension, with the hope that version, permiss...
Read the full discussion on Dev.to
This article was aggregated from Dev.to. Click to join the conversation.
View on Dev.to