Which maintenance operation reclaims space from dead tuples without an exclusive table lock?
- A VACUUM FULL
- B Autovacuum / plain VACUUM (correct answer)
- C REINDEX
- D CLUSTER
Shortcut: Plain VACUUM marks dead tuple space reusable while allowing concurrent reads and writes. VACUUM FULL rewrites the table and takes an ACCESS EXCLUSIVE lock.