medium10 pts · first answer countspostgresqlmvcc

Why PostgreSQL needs VACUUM

Why does PostgreSQL need VACUUM (or autovacuum) on tables with many UPDATEs?

A.To rebuild all indexes from scratch every nightB.To copy the table to replicasC.To compress rows so they use less memory in shared_buffersD.Because UPDATE writes a new row version, and the old dead versions must be cleaned up so their space can be reused

← Non-repeatable read What PITR needs →