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.00033939695
Overall Rank
101 | 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.00058631912
127 Trio: A System for Integrated Management of Data, Accuracy, and Lineage 2005 CIDR 0.00030337791
128 The Design of the Borealis Stream Processing Engine 2005 CIDR 0.00030317705
503 Design of Flash-Based DBMS: An In-Page Logging Approach 2007 SIGMOD 0.00017231771
571 A Case for Flash Memory SSD in Enterprise Database Applications 2008 SIGMOD 0.00016168887
686 Access Methods For Multiversion Data 1989 SIGMOD 0.00014736882
725 Serializable Snapshot Isolation in PostgreSQL 2012 VLDB 0.00014434166
888 Requirements for Science Data Bases and SciDB 2009 CIDR 0.00013213294
1,419 A Demonstration of SciDB: A Science-Oriented DBMS 2009 VLDB 0.00010704914
2,144 Integrating Reliable Memory in Databases 1997 VLDB 8.9631069e-05
2,489 Timeline Index: A Unified Data Structure for Processing Queries on Temporal Data in SAP HANA 2013 SIGMOD 8.379041e-05
2,732 x-RDF-3X: Fast Querying, High Update Rates, and Consistency for RDF Databases 2010 VLDB 8.0665111e-05
2,857 Transaction Time Indexing with Version Compression 2008 VLDB 7.9152217e-05
3,037 Autoscaling Tiered Cloud Storage in Anna 2019 VLDB 7.7086155e-05
3,085 The Performance Of A Multiversion Access Method 1990 SIGMOD 7.6466479e-05
3,108 Skippy: a New Snapshot Indexing Method for Time Travel in the Storage Manager 2008 SIGMOD 7.6237576e-05
3,121 High-Concurrency Locking in R-Trees 1995 VLDB 7.6094637e-05
3,570 The O2 Object Manager: an Overview 1989 VLDB 7.1808962e-05
4,946 Fossilized Index: The Linchpin of Trustworthy Non-Alterable Electronic Records 2005 SIGMOD 6.3285105e-05
5,086 Tamper Detection in Audit Logs 2004 VLDB 6.2670812e-05
5,528 A Cost-Effective Method for Providing Improved Data Availability During DBMS Restart Recovery After a Failure 1993 VLDB 6.0795275e-05
5,605 How Good is My HTAP System? 2022 SIGMOD 6.0511725e-05
5,750 Durable Write Cache in Flash Memory SSD for Relational and NoSQL Databases 2014 SIGMOD 5.9907271e-05
6,507 FineLine: Log-structured Transactional Storage and Recovery 2018 VLDB 5.7453056e-05
6,610 Research Directions in Object-Oriented Database Systems 1990 PODS 5.7180274e-05
6,667 Hindsight Logging for Model Training 2021 VLDB 5.6985871e-05
7,090 Transaction Timestamping in (Temporal) Databases 2001 VLDB 5.5872424e-05
7,754 Query Processing Techniques for Multiversion Access Methods 1996 VLDB 5.443551e-05
8,820 Retrieval Performance Versus Disc Space Utilization on WORM Optical Discs 1989 SIGMOD 5.2558042e-05
8,985 Recovery from "Bad" User Transactions 2006 SIGMOD 5.2311402e-05
9,830 TiQuE: Improving the Transactional Performance of Analytical Systems for True Hybrid Workloads 2023 VLDB 5.1065586e-05
12,790 Peer coordination through distributed triggers 2010 VLDB 4.9605343e-05
13,273 Querying Continuous Time Sequences 1998 VLDB 4.9605343e-05
13,406 Exploiting A History Database for Backup 1993 VLDB 4.9605343e-05
13,500 A logical framework for temporal deductive databases 1988 VLDB 4.9605343e-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.0019892478
7 Implementation Techniques For Main Memory Database Systems 1984 SIGMOD 0.00081781676
34 The Design Of Postgres 1986 SIGMOD 0.00049063803
59 Differential Files: Their Application To The Maintenance Of Large Data Bases 1976 SIGMOD 0.00039478403
116 Direct Spatial Search on Pictorial Databases Using Packed R-trees 1985 SIGMOD 0.00031562001
150 Making Smalltalk a Database System 1984 SIGMOD 0.00028835071
270 Models for Studying Concurrency Control Performance: Alternatives and Implications 1985 SIGMOD 0.00022604714
297 Object and File Management in the EXODUS Extensible Database System 1986 VLDB 0.0002187415
Previous Page 1 / 1 Next

Semantically Similar Papers

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