DBScholar

Back to papers

The Design of the POSTGRES Storage System

Summary: POSTGRES’s storage manager provides transactional recovery without WAL or recovery code, enabling essentially instantaneous crash recovery. It uniquely integrates optional full object-history archival and asynchronous processes, preserving parallelism while remaining competitive with WAL systems. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID
hb381d51ed4984b61
Venue
VLDB
Year
1987
Pagerank
0.00034019355
Overall Rank
99 | 99.34%
DOI
-

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{stonebraker_vldb87,
        title = {{The Design of the POSTGRES Storage System}},
        author = {Stonebraker, Michael},
        journal = {PVLDB},
        series = {{VLDB} '87},
        pages = {289},
        year = {1987}
}

Incoming Citations (Sorted by Pagerank)

Showing 35 of 35 citing papers.

Rank Citing Paper Year Venue Pagerank
19 A Critique of ANSI SQL Isolation Levels 1995 SIGMOD 0.00058759613
126 Trio: A System for Integrated Management of Data, Accuracy, and Lineage 2005 CIDR 0.00030430114
127 The Design of the Borealis Stream Processing Engine 2005 CIDR 0.00030414379
500 Design of Flash-Based DBMS: An In-Page Logging Approach 2007 SIGMOD 0.00017285624
570 A Case for Flash Memory SSD in Enterprise Database Applications 2008 SIGMOD 0.00016218388
687 Access Methods For Multiversion Data 1989 SIGMOD 0.00014757083
727 Serializable Snapshot Isolation in PostgreSQL 2012 VLDB 0.00014456009
887 Requirements for Science Data Bases and SciDB 2009 CIDR 0.00013252692
1,409 A Demonstration of SciDB: A Science-Oriented DBMS 2009 VLDB 0.00010738582
2,131 Integrating Reliable Memory in Databases 1997 VLDB 8.9918109e-05
2,611 Timeline Index: A Unified Data Structure for Processing Queries on Temporal Data in SAP HANA 2013 SIGMOD 8.2237793e-05
2,722 x-RDF-3X: Fast Querying, High Update Rates, and Consistency for RDF Databases 2010 VLDB 8.0926355e-05
2,847 Transaction Time Indexing with Version Compression 2008 VLDB 7.9411756e-05
3,029 Autoscaling Tiered Cloud Storage in Anna 2019 VLDB 7.7341355e-05
3,079 The Performance Of A Multiversion Access Method 1990 SIGMOD 7.6710967e-05
3,099 Skippy: a New Snapshot Indexing Method for Time Travel in the Storage Manager 2008 SIGMOD 7.6488203e-05
3,113 High-Concurrency Locking in R-Trees 1995 VLDB 7.633977e-05
3,561 The O2 Object Manager: an Overview 1989 VLDB 7.2040741e-05
4,921 Fossilized Index: The Linchpin of Trustworthy Non-Alterable Electronic Records 2005 SIGMOD 6.3495059e-05
5,066 Tamper Detection in Audit Logs 2004 VLDB 6.2878728e-05
5,506 A Cost-Effective Method for Providing Improved Data Availability During DBMS Restart Recovery After a Failure 1993 VLDB 6.0994349e-05
5,712 How Good is My HTAP System? 2022 SIGMOD 6.0193298e-05
5,738 Durable Write Cache in Flash Memory SSD for Relational and NoSQL Databases 2014 SIGMOD 6.0105141e-05
6,495 FineLine: Log-structured Transactional Storage and Recovery 2018 VLDB 5.7640595e-05
6,604 Research Directions in Object-Oriented Database Systems 1990 PODS 5.736996e-05
6,656 Hindsight Logging for Model Training 2021 VLDB 5.7174927e-05
7,069 Transaction Timestamping in (Temporal) Databases 2001 VLDB 5.6057786e-05
7,740 Query Processing Techniques for Multiversion Access Methods 1996 VLDB 5.4614278e-05
8,802 Retrieval Performance Versus Disc Space Utilization on WORM Optical Discs 1989 SIGMOD 5.2732408e-05
8,965 Recovery from "Bad" User Transactions 2006 SIGMOD 5.2484938e-05
9,797 TiQuE: Improving the Transactional Performance of Analytical Systems for True Hybrid Workloads 2023 VLDB 5.1235001e-05
12,747 Peer coordination through distributed triggers 2010 VLDB 4.9769913e-05
13,232 Querying Continuous Time Sequences 1998 VLDB 4.9769913e-05
13,365 Exploiting A History Database for Backup 1993 VLDB 4.9769913e-05
13,459 A logical framework for temporal deductive databases 1988 VLDB 4.9769913e-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.0019923528
7 Implementation Techniques For Main Memory Database Systems 1984 SIGMOD 0.00081971778
34 The Design Of Postgres 1986 SIGMOD 0.00049129967
59 Differential Files: Their Application To The Maintenance Of Large Data Bases 1976 SIGMOD 0.00039592759
116 Direct Spatial Search on Pictorial Databases Using Packed R-trees 1985 SIGMOD 0.00031633451
150 Making Smalltalk a Database System 1984 SIGMOD 0.00028917874
268 Models for Studying Concurrency Control Performance: Alternatives and Implications 1985 SIGMOD 0.00022664149
291 Object and File Management in the EXODUS Extensible Database System 1986 VLDB 0.00021940923
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 2,441 A Case for Staged Database Systems 2003 CIDR
2 12 C-Store: A Column-oriented DBMS 2005 VLDB
3 499 The Design of XPRS 1988 VLDB
4 5,306 Segment-Based Recovery: Write-ahead logging revisited 2009 VLDB
5 5,681 Recovery Architectures for Multiprocessor Database Machines 1985 SIGMOD
6 1,437 Write-Behind Logging 2017 VLDB
7 2,146 A Recovery Algorithm for A High-Performance Memory-Resident Database System 1987 SIGMOD
8 7,079 Understanding the Performance Implications of the Design Principles in Storage-Disaggregated Databases 2024 SIGMOD
9 3,846 Query Processing in Tertiary Memory Databases 1995 VLDB
10 34 The Design Of Postgres 1986 SIGMOD