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
8002
Venue
VLDB
Year
1987
Pagerank
0.00034506601
Overall Rank
99 | 99.33%
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.00058720861
125 Trio: A System for Integrated Management of Data, Accuracy, and Lineage 2005 CIDR 0.00030932014
127 The Design of the Borealis Stream Processing Engine 2005 CIDR 0.00030738755
488 Design of Flash-Based DBMS: An In-Page Logging Approach 2007 SIGMOD 0.00017615543
561 A Case for Flash Memory SSD in Enterprise Database Applications 2008 SIGMOD 0.00016525248
681 Access Methods For Multiversion Data 1989 SIGMOD 0.0001502579
733 Serializable Snapshot Isolation in PostgreSQL 2012 VLDB 0.00014533437
868 Requirements for Science Data Bases and SciDB 2009 CIDR 0.00013504796
1,376 A Demonstration of SciDB: A Science-Oriented DBMS 2009 VLDB 0.00010973814
2,092 Integrating Reliable Memory in Databases 1997 VLDB 9.185168e-05
2,568 Timeline Index: A Unified Data Structure for Processing Queries on Temporal Data in SAP HANA 2013 SIGMOD 8.4096765e-05
2,669 x-RDF-3X: Fast Querying, High Update Rates, and Consistency for RDF Databases 2010 VLDB 8.2742823e-05
2,824 Transaction Time Indexing with Version Compression 2008 VLDB 8.0882727e-05
3,033 The Performance Of A Multiversion Access Method 1990 SIGMOD 7.8303009e-05
3,038 Skippy: a New Snapshot Indexing Method for Time Travel in the Storage Manager 2008 SIGMOD 7.8272965e-05
3,057 High-Concurrency Locking in R-Trees 1995 VLDB 7.807389e-05
3,320 Autoscaling Tiered Cloud Storage in Anna 2019 VLDB 7.5223482e-05
3,488 The O2 Object Manager: an Overview 1989 VLDB 7.3679662e-05
4,810 Fossilized Index: The Linchpin of Trustworthy Non-Alterable Electronic Records 2005 SIGMOD 6.4983179e-05
4,936 Tamper Detection in Audit Logs 2004 VLDB 6.4352403e-05
5,375 A Cost-Effective Method for Providing Improved Data Availability During DBMS Restart Recovery After a Failure 1993 VLDB 6.2416129e-05
5,602 How Good is My HTAP System? 2022 SIGMOD 6.1538237e-05
5,625 Durable Write Cache in Flash Memory SSD for Relational and NoSQL Databases 2014 SIGMOD 6.1448053e-05
6,464 Research Directions in Object-Oriented Database Systems 1990 PODS 5.8714103e-05
6,512 FineLine: Log-structured Transactional Storage and Recovery 2018 VLDB 5.8563029e-05
6,525 Hindsight Logging for Model Training 2021 VLDB 5.8514923e-05
6,927 Transaction Timestamping in (Temporal) Databases 2001 VLDB 5.73716e-05
7,595 Query Processing Techniques for Multiversion Access Methods 1996 VLDB 5.5888857e-05
8,628 Retrieval Performance Versus Disc Space Utilization on WORM Optical Discs 1989 SIGMOD 5.3968286e-05
8,793 Recovery from "Bad" User Transactions 2006 SIGMOD 5.3714948e-05
10,058 TiQuE: Improving the Transactional Performance of Analytical Systems for True Hybrid Workloads 2023 VLDB 5.1664022e-05
12,450 Peer coordination through distributed triggers 2010 VLDB 5.093636e-05
12,936 Querying Continuous Time Sequences 1998 VLDB 5.093636e-05
13,069 Exploiting A History Database for Backup 1993 VLDB 5.093636e-05
13,163 A logical framework for temporal deductive databases 1988 VLDB 5.093636e-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.0020210012
7 Implementation Techniques For Main Memory Database Systems 1984 SIGMOD 0.00083340894
34 The Design Of Postgres 1986 SIGMOD 0.00049302774
59 Differential Files: Their Application To The Maintenance Of Large Data Bases 1976 SIGMOD 0.00040060625
116 Direct Spatial Search on Pictorial Databases Using Packed R-trees 1985 SIGMOD 0.0003221055
147 Making Smalltalk a Database System 1984 SIGMOD 0.00029474235
260 Models for Studying Concurrency Control Performance: Alternatives and Implications 1985 SIGMOD 0.00023103999
283 Object and File Management in the EXODUS Extensible Database System 1986 VLDB 0.00022377907
Previous Page 1 / 1 Next

Semantically Similar Papers

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