Database Paper Browser

Back to papers

The Design Of The Postgres Storage System

Summary: POSTGRES storage manager: transactions without WAL; crash recovery essentially instant; no recovery-time code. Optional history archival via storage; asynchronous, modular design for parallelism; performance competitive with WAL in practice. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
7812
Venue
VLDB
Year
1987
Pagerank
0.00082350905
Overall Rank
26 | 99.83%
DOI
-

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 35 of 35 citing papers.

Rank Citing Paper Year Venue Pagerank
23 A Critique of ANSI SQL Isolation Levels 1995 SIGMOD 0.00083899338
149 Trio: A System for Integrated Management of Data, Accuracy, and Lineage 2005 CIDR 0.00041085859
191 The Design of the Borealis Stream Processing Engine 2005 CIDR 0.00035714897
347 Design of Flash-Based DBMS: An In-Page Logging Approach 2007 SIGMOD 0.0002656744
492 A Case for Flash Memory SSD in Enterprise Database Applications 2008 SIGMOD 0.0002178745
683 Access Methods For Multiversion Data 1989 SIGMOD 0.00018162653
926 Requirements for Science Data Bases and SciDB 2009 CIDR 0.00015237787
956 Serializable Snapshot Isolation in PostgreSQL 2012 VLDB 0.00015068342
1,241 A Demonstration of SciDB: A Science-Oriented DBMS 2009 VLDB 0.00013089816
1,915 Integrating Reliable Memory in Databases 1997 VLDB 0.00010111449
2,920 x-RDF-3X: Fast Querying, High Update Rates, and Consistency for RDF Databases 2010 VLDB 7.8999781e-05
3,010 The Performance Of A Multiversion Access Method 1990 SIGMOD 7.7204737e-05
3,042 High-Concurrency Locking in R-Trees 1995 VLDB 7.6669657e-05
3,048 Skippy: a New Snapshot Indexing Method for Time Travel in the Storage Manager 2008 SIGMOD 7.6522631e-05
3,121 Timeline Index: A Unified Data Structure for Processing Queries on Temporal Data in SAP HANA 2013 SIGMOD 7.532465e-05
3,141 Transaction Time Indexing with Version Compression 2008 VLDB 7.4910063e-05
3,227 The O2 Object Manager: an Overview 1989 VLDB 7.3445433e-05
3,645 Autoscaling Tiered Cloud Storage in Anna 2019 VLDB 6.882432e-05
3,885 Fossilized Index: The Linchpin of Trustworthy Non-Alterable Electronic Records 2005 SIGMOD 6.6611877e-05
4,606 Tamper Detection in Audit Logs 2004 VLDB 6.0489353e-05
4,998 A Cost-Effective Method for Providing Improved Data Availability During DBMS Restart Recovery After a Failure 1993 VLDB 5.7647393e-05
5,804 Durable Write Cache in Flash Memory SSD for Relational and NoSQL Databases 2014 SIGMOD 5.3197672e-05
6,123 Transaction Timestamping in (Temporal) Databases 2001 VLDB 5.1959432e-05
6,465 Research Directions in Object-Oriented Database Systems 1990 PODS 5.0464278e-05
6,518 How Good is My HTAP System? 2022 SIGMOD 5.0250374e-05
6,735 Hindsight Logging for Model Training 2021 VLDB 4.9420202e-05
6,749 FineLine: Log-structured Transactional Storage and Recovery 2018 VLDB 4.9363766e-05
7,601 Query Processing Techniques for Multiversion Access Methods 1996 VLDB 4.6967949e-05
7,985 A logical framework for temporal deductive databases 1988 VLDB 4.6089395e-05
8,399 Retrieval Performance Versus Disc Space Utilization on WORM Optical Discs 1989 SIGMOD 4.5191615e-05
8,514 Recovery from "Bad" User Transactions 2006 SIGMOD 4.4901852e-05
9,903 TiQuE: Improving the Transactional Performance of Analytical Systems for True Hybrid Workloads 2023 VLDB 4.2539423e-05
12,263 Peer coordination through distributed triggers 2010 VLDB 4.1905499e-05
12,752 Querying Continuous Time Sequences 1998 VLDB 4.1905499e-05
12,885 Exploiting A History Database for Backup 1993 VLDB 4.1905499e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 8 of 8 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
2 R-Trees: A Dynamic Index Structure For Spatial Searching 1984 SIGMOD 0.0032118946
9 Implementation Techniques For Main Memory Database Systems 1984 SIGMOD 0.001426258
32 Differential Files: Their Application To The Maintenance Of Large Data Bases 1976 SIGMOD 0.00077553033
44 The Design Of Postgres 1986 SIGMOD 0.00071946446
56 Direct Spatial Search on Pictorial Databases Using Packed R-trees 1985 SIGMOD 0.00065500256
86 Making Smalltalk a Database System 1984 SIGMOD 0.0005348843
187 Object and File Management in the EXODUS Extensible Database System 1986 VLDB 0.00035990623
190 Models for Studying Concurrency Control Performance: Alternatives and Implications 1985 SIGMOD 0.00035797633
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
2,329 A Case for Staged Database Systems 2003 CIDR 9.0237899e-05
20 C-Store: A Column-oriented DBMS 2005 VLDB 0.00086163998
429 The Design Of Xprs 1988 VLDB 0.00023497848
4,780 Segment-Based Recovery: Write-ahead logging revisited 2009 VLDB 5.9256838e-05
3,775 Recovery Architectures for Multiprocessor Database Machines 1985 SIGMOD 6.7728004e-05
1,835 Write-Behind Logging 2017 VLDB 0.00010356306
1,688 A Recovery Algorithm for A High-Performance Memory-Resident Database System 1987 SIGMOD 0.00010898703
7,622 Understanding the Performance Implications of the Design Principles in Storage-Disaggregated Databases 2024 SIGMOD 4.6891172e-05
3,742 Query Processing in Tertiary Memory Databases 1995 VLDB 6.7950057e-05
44 The Design Of Postgres 1986 SIGMOD 0.00071946446