Serializable Snapshot Isolation in PostgreSQL
Summary: First production SSI in PostgreSQL; new lock manager, bounded memory, and deep integration with core features. Read-only SSI extension; benchmarks show near snapshot-isolation performance and clear advantage over 2PL on read-heavy workloads. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Dan R. K. Ports (Massachusetts Institute of Technology)
- 2. Kevin Grittner (Wisconsin Supreme Court)
BibTeX Citation
@article{ports_vldb12,
title = {{Serializable Snapshot Isolation in PostgreSQL}},
author = {Ports, Dan R. K. and Grittner, Kevin},
journal = {PVLDB},
series = {{VLDB} '12},
volume = {5},
number = {12},
pages = {1850--1861},
doi = {10.14778/2367502.2367523},
url = {https://doi.org/10.14778/2367502.2367523},
year = {2012}
}Incoming Citations (Sorted by Pagerank)
Showing 35 of 35 citing papers.
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 7 of 7 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 19 | A Critique of ANSI SQL Isolation Levels | 1995 | SIGMOD | 0.00058631912 |
| 34 | The Design Of Postgres | 1986 | SIGMOD | 0.00049063803 |
| 101 | The Design of the POSTGRES Storage System | 1987 | VLDB | 0.00033939695 |
| 210 | Generalized Search Trees for Database Systems (Extended Abstract) | 1995 | VLDB | 0.00024910589 |
| 221 | ARIES/KVL: A Key-Value Locking Method for Concurrency Control of Multiaction Transactions Operating on B-Tree Indexes | 1990 | VLDB | 0.0002420049 |
| 237 | Serializable Isolation for Snapshot Databases | 2008 | SIGMOD | 0.00023615848 |
| 2,087 | Automating the Detection of Snapshot Isolation Anomalies | 2007 | VLDB | 9.048975e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 14,362 | Testing Isolation Levels of Relational Database Management Systems | 2002 | VLDB |
| 2 | 7,273 | Scalable and Robust Snapshot Isolation for High-Performance Storage Engines | 2023 | VLDB |
| 3 | 11,739 | Allocating Isolation Levels to Transactions in a Multiversion Setting | 2023 | PODS |
| 4 | 2,697 | Allocating Isolation Levels to Transactions | 2005 | PODS |
| 5 | 1,798 | Middleware based Data Replication providing Snapshot Isolation | 2005 | SIGMOD |
| 6 | 781 | Lazy Database Replication with Snapshot Isolation | 2006 | VLDB |
| 7 | 9,633 | TxnSails: Achieving Serializable Transaction Scheduling with Self-Adaptive Isolation Level Selection | 2025 | VLDB |
| 8 | 2,087 | Automating the Detection of Snapshot Isolation Anomalies | 2007 | VLDB |
| 9 | 6,967 | Serializable Snapshot Isolation for Replicated Databases in High-Update Scenarios | 2011 | VLDB |
| 10 | 237 | Serializable Isolation for Snapshot Databases | 2008 | SIGMOD |