|< < 21 > >|

Multiversion Concurrency Control

Snapshot Isolation

MVCC implementations:

Isolation level Oracle Postgres < 9.1 Postgres ≥ 9.1
REPEATABLE READ Allows phantoms (?) Serialization anomalies (SI) Serialization anomalies (SI)
SERIALIZABLE Serialization anomalies (SI) Serialization anomalies (SI) True serializability (SSI)

|< < 21 > >|