← recall

snapshot isolation term

transaction sees a consistent snapshot from its start

Reads don't see writes from concurrent transactions. Implemented via MVCC. Default in Postgres 'repeatable read.' Allows write skew anomalies.

topics: databases, correctness, internals

references:

• DDIA Ch. 7 — Snapshot Isolation
• Postgres — Repeatable Read Isolation