The Design Of Postgres

Summary: Presents POSTGRES, a successor to INGRES, with object support and user extensibility for data types, operators, and access methods. Adds alerters/triggers, forward/backward inference, and simplified crash recovery; hardware-aware design for optical disks, multi-processor workstations, and VLSI, with minimal changes to the relational model. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: h0fadfafe842b33db
Venue: SIGMOD
Year: 1986
Pagerank: 0.00049129967
Overall Rank: 34 | 99.78%
DOI: 10.1145/16894.16888

Incoming Non-self Citations Over Time

Authors

1. Michael Stonebraker (University of California Berkeley)
2. Lawrence A. Rowe (University of California Berkeley)

BibTeX Citation

@inproceedings{stonebraker_sigmod86,
        title = {{THE DESIGN OF POSTGRES}},
        author = {Stonebraker, Michael and Rowe, Lawrence A.},
        series = {{SIGMOD} '86},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/16894.16888},
        url = {https://dl.acm.org/doi/10.1145/16894.16888},
        year = {1986}
}

Incoming Citations (Sorted by Pagerank)

Showing 50 of 105 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
40	The Case for Learned Index Structures	2018	SIGMOD	0.00046363107
93	Encapsulation of Parallelism in the Volcano Query Processing System	1990	SIGMOD	0.00034607573
99	The Design of the POSTGRES Storage System	1987	VLDB	0.00034019355
118	The EXODUS Optimizer Generator	1987	SIGMOD	0.00031381726
125	Predicate Migration: Optimizing Queries with Expensive Predicates	1993	SIGMOD	0.00030462671
147	On Rules, Procedures, Caching And Views In Data Base Systems	1990	SIGMOD	0.00029006574
196	Grammar-like Functional Rules for Representing Query Optimization Alternatives	1988	SIGMOD	0.00025616489
248	Overview of SciDB: Large Scale Array Storage, Processing and Analysis	2010	SIGMOD	0.00023179865
273	Extensible Query Processing in Starburst	1989	SIGMOD	0.00022498382
291	Object and File Management in the EXODUS Extensible Database System	1986	VLDB	0.00021940923
339	AnalyticDB-V: A Hybrid Analytical Engine Towards Query Fusion for Structured and Unstructured Data	2020	VLDB	0.00020561716
499	The Design of XPRS	1988	VLDB	0.00017291748
592	Global Query Optimization	1986	SIGMOD	0.00015835128
631	A Rule-Based View of Query Optimization	1987	SIGMOD	0.00015411265
727	Serializable Snapshot Isolation in PostgreSQL	2012	VLDB	0.00014456009
729	Anti-Caching: A New Approach to Database Management System Architecture	2013	VLDB	0.00014417679
744	Client-Server Paradise	1994	VLDB	0.00014305129
768	FITing-Tree: A Data-aware Index Structure	2019	SIGMOD	0.00014107655
861	An Empirical Evaluation of In-Memory Multi-Version Concurrency Control	2017	VLDB	0.00013401147
952	Programming Constructs for Database System Implementation in EXODUS	1987	SIGMOD	0.00012875776
955	Selectivity Estimation and Query Optimization in Large Databases with Highly Skewed Distributions of Column Values	1988	VLDB	0.0001286095
1,143	The POSTGRES Data Model	1987	VLDB	0.00011842018
1,176	Relational Transducers for Electronic Commerce	1998	PODS	0.00011637508
1,255	A Model of Queries for Object-Oriented Databases	1989	VLDB	0.00011330686
1,350	GraphDB: Modeling and Querying Graphs in Databases	1994	VLDB	0.00010939854
1,411	A Data Management Extension Architecture	1987	SIGMOD	0.00010736094
1,464	Implementing Large Production Systems in a DBMS Environment: Concepts and Algorithms	1988	SIGMOD	0.00010575416
1,740	Split-Transactions for Open-Ended Activities	1988	VLDB	9.7442978e-05
1,871	Composite Objects Revisted	1989	SIGMOD	9.4625332e-05
2,560	Extensible Buffer Management of Indexes	1992	VLDB	8.2955773e-05
2,678	Gral: An Extensible Relational Database System for Geometric Applications	1989	VLDB	8.141803e-05
2,766	LogBase: A Scalable Log-structured Database System in the Cloud	2012	VLDB	8.039771e-05
2,828	Segment Indexes: Dynamic Indexing Techniques for Multi-Dimensional Interval Data	1991	SIGMOD	7.9613943e-05
2,952	Constant Time Recovery in Azure SQL Database	2019	VLDB	7.8143358e-05
3,038	Monitoring Database Objects	1989	VLDB	7.7276794e-05
3,211	Implementing an Interpreter for Functional Rules in a Query Optimizer	1988	VLDB	7.5331392e-05
3,295	Implementation of a Compiler for a Semantic Data Model: Experiences with Taxis	1987	SIGMOD	7.4452378e-05
3,464	DBOS: A DBMS-oriented Operating System	2022	VLDB	7.2788609e-05
3,465	Querying in highly mobile distributed environments	1992	VLDB	7.2786525e-05
3,530	Extended User-Defined Indexing with Application to Textual Databases	1988	VLDB	7.2243276e-05
3,592	Two Birds, One Stone: A Fast, yet Lightweight, Indexing Scheme for Modern Database Systems	2017	VLDB	7.1807308e-05
3,860	OODB Indexing by Class-Division	1995	SIGMOD	6.9634868e-05
4,221	Efficiently Supporting Procedures In Relational Database Systems	1987	SIGMOD	6.7207714e-05
4,222	Citus: Distributed PostgreSQL for Data-Intensive Applications	2021	SIGMOD	6.7205688e-05
4,435	PRIMA - a DBMS Prototype Supporting Engineering Applications	1987	VLDB	6.5984976e-05
4,487	Threats to Privacy in the Forensic Analysis of Database Systems	2007	SIGMOD	6.5767385e-05
4,823	Processing Queries Against Database Procedures: A Performance Analysis	1988	SIGMOD	6.3925758e-05
5,350	Using Write Protected Data Structures To Improve Software Fault Tolerance in Highly Available Database Management Systems	1991	VLDB	6.1677667e-05
5,480	Storage Reclamation in Object Oriented Database Systems	1987	SIGMOD	6.1132428e-05
5,493	Keep CALM and CRDT On	2023	VLDB	6.1066893e-05

Outgoing Citations (Sorted by Pagerank)

Showing 13 of 13 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
8	The K-D-B-Tree: A Search Structure for Large Multidimensional Dynamic Indexes	1981	SIGMOD	0.00081200096
59	Differential Files: Their Application To The Maintenance Of Large Data Bases	1976	SIGMOD	0.00039592759
87	Implementation of Integrity Constraints and Views by Query Modification	1975	SIGMOD	0.00035703156
96	The Database Language GEM	1983	SIGMOD	0.00034271712
150	Making Smalltalk a Database System	1984	SIGMOD	0.00028917874
774	Data Abstraction, Views And Updates In Rigel	1979	SIGMOD	0.00014079981
1,126	Quel As A Data Type	1984	SIGMOD	0.00011914952
2,005	Data Constructors: On the Integration of Rules and Relations	1985	VLDB	9.2054351e-05
2,039	An Extensible Object-Oriented Approach to Databases for VLSI/CAD	1985	VLDB	9.1482843e-05
2,536	Database Portals: A New Application Program Interface	1984	VLDB	8.3294304e-05
2,752	An Implementation of Hypothetical Relations	1983	VLDB	8.0520473e-05
3,197	"Fill-in-the-Form" Programming	1985	VLDB	7.5432017e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	1,264	Don't be lazy, be consistent: Postgres-R, A new way to implement Database Replication	2000	VLDB
2	1,844	A Performance Study of Query Optimization Algorithms on a Database System Supporting Procedures	1988	VLDB
3	46	Benchmarking Database Systems: A Systematic Approach	1983	VLDB
4	7,429	An Automated, Yet Interactive and Portable DB Designer	2010	SIGMOD
5	405	Distributed Query Processing In A Relational Data Base System	1978	SIGMOD
6	499	The Design of XPRS	1988	VLDB
7	4,221	Efficiently Supporting Procedures In Relational Database Systems	1987	SIGMOD
8	3,846	Query Processing in Tertiary Memory Databases	1995	VLDB
9	1,143	The POSTGRES Data Model	1987	VLDB
10	99	The Design of the POSTGRES Storage System	1987	VLDB