|< < 2 > >|

Announcements

Additional reading for today

• Postgres isolation levels
• Snapshot Isolation
• Very detailed overview of Postgres MVCC
• The Postgres Visibility Map
• Postgres MVCC and Vacuum

More detail

• Why Uber abandoned Postgres for MySQL
• Serializable Snapshot Isolation: Real world problems with SI; extends the theory of SSI; describes the implementation of SSI for Postgres 9.1.
• Brief survey of MVCC implementations: Three very different implementations — Postgres, Oracle, MS SQL Server.
• Postgres system columns: xmin, xmax, ctid.
• Heap-only tuples

|< < 2 > >|