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
10423
Venue
VLDB
Year
2012
Pagerank
0.00015068342
Overall Rank
956 | 93.36%
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
339 OLTP-Bench: An Extensible Testbed for Benchmarking Relational Databases 2014 VLDB 0.00026895683
363 CockroachDB: The Resilient Geo-Distributed SQL Database 2020 SIGMOD 0.00025750338
419 Fast Serializable Multi-Version Concurrency Control for Main-Memory Database Systems 2015 SIGMOD 0.00023720294
1,036 ERMIA: Fast Memory-Optimized Database System for Heterogeneous Workloads 2016 SIGMOD 0.00014515226
1,066 Cicada: Dependably Fast Multi-Core In-Memory Transactions 2017 SIGMOD 0.00014340396
1,273 Amazon Redshift Re-invented 2022 SIGMOD 0.00012870386
1,979 Blockchain Meets Database: Design and Implementation of a Blockchain Relational Database 2019 VLDB 9.8749371e-05
2,431 Decibel: The Relational Dataset Branching System 2016 VLDB 8.8259664e-05
2,827 Price-Optimal Querying with Data APIs 2016 VLDB 8.055521e-05
3,070 HAWQ: A Massively Parallel Processing SQL Engine in Hadoop 2014 SIGMOD 7.6157391e-05
3,747 BCC: Reducing False Aborts in Optimistic Concurrency Control with Low Cost for In-Memory Databases 2016 VLDB 6.7883562e-05
5,101 Accelerating Analytical Processing in MVCC using Fine-Granular High-Frequency Virtual Snapshotting 2018 SIGMOD 5.6938328e-05
6,521 Transaction Repair for Multi-Version Concurrency Control 2017 SIGMOD 5.0235836e-05
6,858 When Private Blockchain Meets Deterministic Database 2023 SIGMOD 4.9013358e-05
7,029 Bringing Modular Concurrency Control to the Next Level 2017 SIGMOD 4.8521438e-05
7,140 Everything is a Transaction: Unifying Logical Concurrency Control and Physical Data Structure Maintenance in Database Management Systems 2021 CIDR 4.8153926e-05
7,164 A Lightweight and Efficient Temporal Database Management System in TDSQL 2019 VLDB 4.8084771e-05
7,424 Memory-Optimized Multi-Version Concurrency Control for Disk-Based Database Systems 2022 VLDB 4.7293034e-05
7,687 Towards Optimal Transaction Scheduling 2024 VLDB 4.6745165e-05
7,734 AeonG: An Efficient Built-in Temporal Support in Graph Databases 2024 VLDB 4.6599626e-05
7,866 Two Birds With One Stone: Designing a Hybrid Cloud Storage Engine for HTAP 2024 VLDB 4.6282779e-05
8,165 Scalable and Robust Snapshot Isolation for High-Performance Storage Engines 2023 VLDB 4.5680112e-05
8,365 NeurDB: On the Design and Implementation of an AI-powered Autonomous Database 2025 CIDR 4.5305127e-05
10,565 Efficient Concurrent Updates to Persistent Randomized Binary Search Trees 2025 VLDB 4.1905499e-05
10,630 Simple Testing Can Expose Most Critical Transaction Bugs: Understanding and Detecting Write-Specific Serializability Violations in Database Systems 2025 VLDB 4.1905499e-05
10,633 Fair Transaction Processing for Multi-Tenant Databases 2025 VLDB 4.1905499e-05
10,649 Using Read Promotion and Mixed Isolation Levels for Performant Yet Serializable Execution of Transaction Programs 2025 VLDB 4.1905499e-05
10,685 Sonata: Multi-Database Transactions Made Fast and Serializable 2025 VLDB 4.1905499e-05
10,736 TxnSails: Achieving Serializable Transaction Scheduling with Self-Adaptive Isolation Level Selection 2025 VLDB 4.1905499e-05
10,911 When View- and Conflict-Robustness Coincide for Multiversion Concurrency Control 2024 PODS 4.1905499e-05
11,168 Allocating Isolation Levels to Transactions in a Multiversion Setting 2023 PODS 4.1905499e-05
11,183 MRVs: Enforcing Numeric Invariants in Parallel Updates to Hotspots with Randomized Splitting 2023 SIGMOD 4.1905499e-05
11,379 In-Page Shadowing and Two-Version Timestamp Ordering for Mobile DBMSs 2022 VLDB 4.1905499e-05
11,454 Efficient Deterministic Concurrency Control Under Practical Isolation Levels 2021 SIGMOD 4.1905499e-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.00083899338
26 The Design Of The Postgres Storage System 1987 VLDB 0.00082350905
44 The Design Of Postgres 1986 SIGMOD 0.00071946446
175 ARIES/KVL: A Key-Value Locking Method for Concurrency Control of Multiaction Transactions Operating on B-Tree Indexes 1990 VLDB 0.00038354115
242 Generalized Search Trees for Database Systems (Extended Abstract) 1995 VLDB 0.00031093647
348 Serializable Isolation for Snapshot Databases 2008 SIGMOD 0.00026473778
2,132 Automating the Detection of Snapshot Isolation Anomalies 2007 VLDB 9.47431e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
13,819 Testing Isolation Levels of Relational Database Management Systems 2002 VLDB -
8,165 Scalable and Robust Snapshot Isolation for High-Performance Storage Engines 2023 VLDB 4.5680112e-05
11,168 Allocating Isolation Levels to Transactions in a Multiversion Setting 2023 PODS 4.1905499e-05
2,653 Allocating Isolation Levels to Transactions 2005 PODS 8.3657356e-05
1,748 Middleware based Data Replication providing Snapshot Isolation 2005 SIGMOD 0.00010686096
591 Lazy Database Replication with Snapshot Isolation 2006 VLDB 0.00019545141
10,736 TxnSails: Achieving Serializable Transaction Scheduling with Self-Adaptive Isolation Level Selection 2025 VLDB 4.1905499e-05
2,132 Automating the Detection of Snapshot Isolation Anomalies 2007 VLDB 9.47431e-05
6,725 Serializable Snapshot Isolation for Replicated Databases in High-Update Scenarios 2011 VLDB 4.9448714e-05
348 Serializable Isolation for Snapshot Databases 2008 SIGMOD 0.00026473778