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

PostgreSQL uses MVCC (Multi-Version Concurrency Control).Each UPDATE inserts a new row version (xmin = current XID) and marks the old one dead (xmax = current XID).Each DELETE marks the row dead by setting xmax. Dead tuples remain on disk, still refe...