How PostgreSQL VACUUM Works: Dead Tuples, FSM/VM, and Locking

A detailed guide to PostgreSQL VACUUM. Learn how dead tuples are cleaned, how the Free Space Map (FSM) and Visibility Map (VM) work, the difference between