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.00034033763
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.00058781151
126 Trio: A System for Integrated Management of Data, Accuracy, and Lineage 2005 CIDR 0.00030439683
127 The Design of the Borealis Stream Processing Engine 2005 CIDR 0.00030427614
499 Design of Flash-Based DBMS: An In-Page Logging Approach 2007 SIGMOD 0.0001729286
570 A Case for Flash Memory SSD in Enterprise Database Applications 2008 SIGMOD 0.00016224945
687 Access Methods For Multiversion Data 1989 SIGMOD 0.00014763858
726 Serializable Snapshot Isolation in PostgreSQL 2012 VLDB 0.00014459037
887 Requirements for Science Data Bases and SciDB 2009 CIDR 0.00013258595
1,408 A Demonstration of SciDB: A Science-Oriented DBMS 2009 VLDB 0.00010743556
2,131 Integrating Reliable Memory in Databases 1997 VLDB 8.9954459e-05
2,611 Timeline Index: A Unified Data Structure for Processing Queries on Temporal Data in SAP HANA 2013 SIGMOD 8.2275795e-05
2,721 x-RDF-3X: Fast Querying, High Update Rates, and Consistency for RDF Databases 2010 VLDB 8.0964644e-05
2,847 Transaction Time Indexing with Version Compression 2008 VLDB 7.9447157e-05
3,028 Autoscaling Tiered Cloud Storage in Anna 2019 VLDB 7.7377953e-05
3,077 The Performance Of A Multiversion Access Method 1990 SIGMOD 7.6745669e-05
3,097 Skippy: a New Snapshot Indexing Method for Time Travel in the Storage Manager 2008 SIGMOD 7.6524049e-05
3,111 High-Concurrency Locking in R-Trees 1995 VLDB 7.6374094e-05
3,559 The O2 Object Manager: an Overview 1989 VLDB 7.2074755e-05
4,920 Fossilized Index: The Linchpin of Trustworthy Non-Alterable Electronic Records 2005 SIGMOD 6.3525131e-05
5,063 Tamper Detection in Audit Logs 2004 VLDB 6.2908508e-05
5,503 A Cost-Effective Method for Providing Improved Data Availability During DBMS Restart Recovery After a Failure 1993 VLDB 6.1023203e-05
5,711 How Good is My HTAP System? 2022 SIGMOD 6.0221783e-05
5,737 Durable Write Cache in Flash Memory SSD for Relational and NoSQL Databases 2014 SIGMOD 6.0133439e-05
6,494 FineLine: Log-structured Transactional Storage and Recovery 2018 VLDB 5.7659228e-05
6,602 Research Directions in Object-Oriented Database Systems 1990 PODS 5.7397128e-05
6,652 Hindsight Logging for Model Training 2021 VLDB 5.7202005e-05
7,067 Transaction Timestamping in (Temporal) Databases 2001 VLDB 5.6084335e-05
7,734 Query Processing Techniques for Multiversion Access Methods 1996 VLDB 5.4640143e-05
8,794 Retrieval Performance Versus Disc Space Utilization on WORM Optical Discs 1989 SIGMOD 5.2757382e-05
8,957 Recovery from "Bad" User Transactions 2006 SIGMOD 5.2509795e-05
9,791 TiQuE: Improving the Transactional Performance of Analytical Systems for True Hybrid Workloads 2023 VLDB 5.1259267e-05
12,741 Peer coordination through distributed triggers 2010 VLDB 4.9793485e-05
13,226 Querying Continuous Time Sequences 1998 VLDB 4.9793485e-05
13,359 Exploiting A History Database for Backup 1993 VLDB 4.9793485e-05
13,453 A logical framework for temporal deductive databases 1988 VLDB 4.9793485e-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.001992968
7 Implementation Techniques For Main Memory Database Systems 1984 SIGMOD 0.00081992507
34 The Design Of Postgres 1986 SIGMOD 0.00049142315
59 Differential Files: Their Application To The Maintenance Of Large Data Bases 1976 SIGMOD 0.00039605949
116 Direct Spatial Search on Pictorial Databases Using Packed R-trees 1985 SIGMOD 0.00031645463
150 Making Smalltalk a Database System 1984 SIGMOD 0.00028930192
268 Models for Studying Concurrency Control Performance: Alternatives and Implications 1985 SIGMOD 0.00022673125
291 Object and File Management in the EXODUS Extensible Database System 1986 VLDB 0.00021951101
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 2,440 A Case for Staged Database Systems 2003 CIDR
2 12 C-Store: A Column-oriented DBMS 2005 VLDB
3 498 The Design of XPRS 1988 VLDB
4 5,303 Segment-Based Recovery: Write-ahead logging revisited 2009 VLDB
5 5,680 Recovery Architectures for Multiprocessor Database Machines 1985 SIGMOD
6 1,437 Write-Behind Logging 2017 VLDB
7 2,145 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,845 Query Processing in Tertiary Memory Databases 1995 VLDB
10 34 The Design Of Postgres 1986 SIGMOD