Postgres MVCC
Postgres uses Multiversion Concurrency Control.
Serializable Snapshot Isolation has been supported since Postgres 9.1.
- REPEATABLE READ: Snapshot isolation (as described).
- SERIALIZABLE: Serializable snapshot isolation.
Why study the MVCC implementation?
- To use a database system effectively, you have to understand
what is fast and what is slow.
- Understanding concurrency control is an essential part of this.
- A really good overview
|