Vacuum

A maintenance operation that reclaims storage from dead tuples, updates visibility maps, and refreshes planner statistics. VACUUM runs without exclusive locks; VACUUM FULL rewrites the entire table and requires an exclusive lock.