PostgreSQL Internals — MVCC, WAL, VACUUM

Databasesdbpostgresqlsql

The Question

Explain PostgreSQL's MVCC, WAL, and VACUUM.

What a Strong Answer Covers

• xmin/xmax as transaction IDs (NOT "min/max versions"). WAL for durability. VACUUM = dead tuples.

Related Questions

• ACID
• Indexes
• Clustered vs Non-clustered
• Isolation Levels
• Normalization