MVCC (Multi-Version Concurrency Control)

PostgreSQL's concurrency model. Instead of locking rows during reads, PostgreSQL maintains multiple versions of each row. Readers see a consistent snapshot based on their transaction's start time. Writers create new row versions rather than overwriting in place.