MVCC
Row version = tuple. txmin + txmax visibility rules. Readers don't block writers, writers don't block readers.
Advertisement
Vacuum
Removes dead tuples. Reclaims space. Advances XID horizon. Prevents wraparound.
Advertisement
Autovacuum
Background process. Threshold: scale factor × table size + base. Tune per table via reloptions.