medium10 pts · first answer countspostgresqlmvcc

Disk not freed after a big delete

You deleted 70 percent of a 500 GB PostgreSQL table and ran plain VACUUM, but the file size barely changed. How do you return the space to the OS with minimal downtime?

A.Run VACUUM again until the size dropsB.Restart the serverC.Use pg_repack (or a careful VACUUM FULL in a maintenance window, which locks the table)D.Run ANALYZE

← Deleting a customer takes seconds Bloat from an idle session →