Glossary — in plain language

VACUUM


In plain English

VACUUM is the cleanup job that removes dead row versions and frees their space for reuse. Plain VACUUM does not shrink the file; it marks space as available again. VACUUM FULL rewrites the table to actually give space back to the OS (but locks the table).

Why it matters

Routine vacuuming keeps tables healthy and prevents transaction-ID wraparound. Most clusters rely on autovacuum to do this automatically; manual VACUUM is for catching up or analyzing problems.

Was this helpful?

← Browse the full glossary