Database Paper Browser

Back to papers

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)

Paper ID
10422
Venue
VLDB
Year
2012
Pagerank
0.00015048214
Overall Rank
957 | 93.35%
DOI
-

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 34 of 34 citing papers.

Rank Citing Paper Year Venue Pagerank
340 OLTP-Bench: An Extensible Testbed for Benchmarking Relational Databases 2014 VLDB 0.00026841628
390 CockroachDB: The Resilient Geo-Distributed SQL Database 2020 SIGMOD 0.00024607299
419 Fast Serializable Multi-Version Concurrency Control for Main-Memory Database Systems 2015 SIGMOD 0.00023720338
1,036 ERMIA: Fast Memory-Optimized Database System for Heterogeneous Workloads 2016 SIGMOD 0.0001452166
1,069 Cicada: Dependably Fast Multi-Core In-Memory Transactions 2017 SIGMOD 0.00014319266
1,284 Amazon Redshift Re-invented 2022 SIGMOD 0.00012837822
1,975 Blockchain Meets Database: Design and Implementation of a Blockchain Relational Database 2019 VLDB 9.8844759e-05
2,430 Decibel: The Relational Dataset Branching System 2016 VLDB 8.8330417e-05
2,820 Price-Optimal Querying with Data APIs 2016 VLDB 8.062913e-05
3,066 HAWQ: A Massively Parallel Processing SQL Engine in Hadoop 2014 SIGMOD 7.6221974e-05
3,749 BCC: Reducing False Aborts in Optimistic Concurrency Control with Low Cost for In-Memory Databases 2016 VLDB 6.7907876e-05
5,112 Accelerating Analytical Processing in MVCC using Fine-Granular High-Frequency Virtual Snapshotting 2018 SIGMOD 5.6876077e-05
6,529 Transaction Repair for Multi-Version Concurrency Control 2017 SIGMOD 5.0252405e-05
6,857 When Private Blockchain Meets Deterministic Database 2023 SIGMOD 4.906043e-05
7,028 Bringing Modular Concurrency Control to the Next Level 2017 SIGMOD 4.856636e-05
7,142 Everything is a Transaction: Unifying Logical Concurrency Control and Physical Data Structure Maintenance in Database Management Systems 2021 CIDR 4.8197508e-05
7,165 A Lightweight and Efficient Temporal Database Management System in TDSQL 2019 VLDB 4.8130937e-05
7,431 Memory-Optimized Multi-Version Concurrency Control for Disk-Based Database Systems 2022 VLDB 4.7316464e-05
7,696 Towards Optimal Transaction Scheduling 2024 VLDB 4.6754222e-05
7,735 AeonG: An Efficient Built-in Temporal Support in Graph Databases 2024 VLDB 4.6644355e-05
7,876 Two Birds With One Stone: Designing a Hybrid Cloud Storage Engine for HTAP 2024 VLDB 4.6298182e-05
8,192 Scalable and Robust Snapshot Isolation for High-Performance Storage Engines 2023 VLDB 4.562388e-05
8,688 NeurDB: On the Design and Implementation of an AI-powered Autonomous Database 2025 CIDR 4.4673127e-05
10,556 Efficient Concurrent Updates to Persistent Randomized Binary Search Trees 2025 VLDB 4.1945683e-05
10,622 Simple Testing Can Expose Most Critical Transaction Bugs: Understanding and Detecting Write-Specific Serializability Violations in Database Systems 2025 VLDB 4.1945683e-05
10,625 Fair Transaction Processing for Multi-Tenant Databases 2025 VLDB 4.1945683e-05
10,641 Using Read Promotion and Mixed Isolation Levels for Performant Yet Serializable Execution of Transaction Programs 2025 VLDB 4.1945683e-05
10,677 Sonata: Multi-Database Transactions Made Fast and Serializable 2025 VLDB 4.1945683e-05
10,729 TxnSails: Achieving Serializable Transaction Scheduling with Self-Adaptive Isolation Level Selection 2025 VLDB 4.1945683e-05
10,907 When View- and Conflict-Robustness Coincide for Multiversion Concurrency Control 2024 PODS 4.1945683e-05
11,165 Allocating Isolation Levels to Transactions in a Multiversion Setting 2023 PODS 4.1945683e-05
11,180 MRVs: Enforcing Numeric Invariants in Parallel Updates to Hotspots with Randomized Splitting 2023 SIGMOD 4.1945683e-05
11,377 In-Page Shadowing and Two-Version Timestamp Ordering for Mobile DBMSs 2022 VLDB 4.1945683e-05
11,451 Efficient Deterministic Concurrency Control Under Practical Isolation Levels 2021 SIGMOD 4.1945683e-05
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
23 A Critique of ANSI SQL Isolation Levels 1995 SIGMOD 0.00083894938
26 The Design Of The Postgres Storage System 1987 VLDB 0.00082378685
44 The Design Of Postgres 1986 SIGMOD 0.00071838587
174 ARIES/KVL: A Key-Value Locking Method for Concurrency Control of Multiaction Transactions Operating on B-Tree Indexes 1990 VLDB 0.00038347904
242 Generalized Search Trees for Database Systems (Extended Abstract) 1995 VLDB 0.00031110894
349 Serializable Isolation for Snapshot Databases 2008 SIGMOD 0.00026440605
2,133 Automating the Detection of Snapshot Isolation Anomalies 2007 VLDB 9.4752131e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
13,805 Testing Isolation Levels of Relational Database Management Systems 2002 VLDB -
8,192 Scalable and Robust Snapshot Isolation for High-Performance Storage Engines 2023 VLDB 4.562388e-05
11,165 Allocating Isolation Levels to Transactions in a Multiversion Setting 2023 PODS 4.1945683e-05
2,648 Allocating Isolation Levels to Transactions 2005 PODS 8.3731376e-05
1,749 Middleware based Data Replication providing Snapshot Isolation 2005 SIGMOD 0.00010684686
590 Lazy Database Replication with Snapshot Isolation 2006 VLDB 0.000195762
10,729 TxnSails: Achieving Serializable Transaction Scheduling with Self-Adaptive Isolation Level Selection 2025 VLDB 4.1945683e-05
2,133 Automating the Detection of Snapshot Isolation Anomalies 2007 VLDB 9.4752131e-05
6,731 Serializable Snapshot Isolation for Replicated Databases in High-Update Scenarios 2011 VLDB 4.9479409e-05
349 Serializable Isolation for Snapshot Databases 2008 SIGMOD 0.00026440605