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.00049142315
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.00046284649
93	Encapsulation of Parallelism in the Volcano Query Processing System	1990	SIGMOD	0.00034622929
99	The Design of the POSTGRES Storage System	1987	VLDB	0.00034033763
118	The EXODUS Optimizer Generator	1987	SIGMOD	0.00031392616
125	Predicate Migration: Optimizing Queries with Expensive Predicates	1993	SIGMOD	0.00030470848
147	On Rules, Procedures, Caching And Views In Data Base Systems	1990	SIGMOD	0.00029019485
196	Grammar-like Functional Rules for Representing Query Optimization Alternatives	1988	SIGMOD	0.00025626873
248	Overview of SciDB: Large Scale Array Storage, Processing and Analysis	2010	SIGMOD	0.00023189805
273	Extensible Query Processing in Starburst	1989	SIGMOD	0.00022504729
291	Object and File Management in the EXODUS Extensible Database System	1986	VLDB	0.00021951101
341	AnalyticDB-V: A Hybrid Analytical Engine Towards Query Fusion for Structured and Unstructured Data	2020	VLDB	0.00020539791
498	The Design of XPRS	1988	VLDB	0.00017299238
592	Global Query Optimization	1986	SIGMOD	0.00015841026
630	A Rule-Based View of Query Optimization	1987	SIGMOD	0.0001541799
726	Serializable Snapshot Isolation in PostgreSQL	2012	VLDB	0.00014459037
728	Anti-Caching: A New Approach to Database Management System Architecture	2013	VLDB	0.00014414001
743	Client-Server Paradise	1994	VLDB	0.00014311524
779	FITing-Tree: A Data-aware Index Structure	2019	SIGMOD	0.00014030069
872	An Empirical Evaluation of In-Memory Multi-Version Concurrency Control	2017	VLDB	0.00013342029
952	Programming Constructs for Database System Implementation in EXODUS	1987	SIGMOD	0.00012881214
956	Selectivity Estimation and Query Optimization in Large Databases with Highly Skewed Distributions of Column Values	1988	VLDB	0.00012865801
1,143	The POSTGRES Data Model	1987	VLDB	0.00011847554
1,176	Relational Transducers for Electronic Commerce	1998	PODS	0.00011643011
1,253	A Model of Queries for Object-Oriented Databases	1989	VLDB	0.00011336027
1,350	GraphDB: Modeling and Querying Graphs in Databases	1994	VLDB	0.0001094492
1,411	A Data Management Extension Architecture	1987	SIGMOD	0.00010741047
1,464	Implementing Large Production Systems in a DBMS Environment: Concepts and Algorithms	1988	SIGMOD	0.00010580339
1,738	Split-Transactions for Open-Ended Activities	1988	VLDB	9.7487946e-05
1,870	Composite Objects Revisted	1989	SIGMOD	9.4669909e-05
2,560	Extensible Buffer Management of Indexes	1992	VLDB	8.2993451e-05
2,678	Gral: An Extensible Relational Database System for Geometric Applications	1989	VLDB	8.1456214e-05
2,766	LogBase: A Scalable Log-structured Database System in the Cloud	2012	VLDB	8.0432817e-05
2,828	Segment Indexes: Dynamic Indexing Techniques for Multi-Dimensional Interval Data	1991	SIGMOD	7.9650643e-05
2,951	Constant Time Recovery in Azure SQL Database	2019	VLDB	7.8166642e-05
3,037	Monitoring Database Objects	1989	VLDB	7.7313318e-05
3,209	Implementing an Interpreter for Functional Rules in a Query Optimizer	1988	VLDB	7.5364911e-05
3,294	Implementation of a Compiler for a Semantic Data Model: Experiences with Taxis	1987	SIGMOD	7.4487512e-05
3,463	DBOS: A DBMS-oriented Operating System	2022	VLDB	7.2821994e-05
3,464	Querying in highly mobile distributed environments	1992	VLDB	7.282091e-05
3,530	Extended User-Defined Indexing with Application to Textual Databases	1988	VLDB	7.2276073e-05
3,597	Two Birds, One Stone: A Fast, yet Lightweight, Indexing Scheme for Modern Database Systems	2017	VLDB	7.1788912e-05
3,859	OODB Indexing by Class-Division	1995	SIGMOD	6.9667626e-05
4,221	Efficiently Supporting Procedures In Relational Database Systems	1987	SIGMOD	6.7238906e-05
4,223	Citus: Distributed PostgreSQL for Data-Intensive Applications	2021	SIGMOD	6.7237373e-05
4,432	PRIMA - a DBMS Prototype Supporting Engineering Applications	1987	VLDB	6.601596e-05
4,484	Threats to Privacy in the Forensic Analysis of Database Systems	2007	SIGMOD	6.5798533e-05
4,821	Processing Queries Against Database Procedures: A Performance Analysis	1988	SIGMOD	6.3955453e-05
5,344	Using Write Protected Data Structures To Improve Software Fault Tolerance in Highly Available Database Management Systems	1991	VLDB	6.1706489e-05
5,476	Storage Reclamation in Object Oriented Database Systems	1987	SIGMOD	6.1161354e-05
5,488	Keep CALM and CRDT On	2023	VLDB	6.1095815e-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.001992968
8	The K-D-B-Tree: A Search Structure for Large Multidimensional Dynamic Indexes	1981	SIGMOD	0.0008122792
59	Differential Files: Their Application To The Maintenance Of Large Data Bases	1976	SIGMOD	0.00039605949
87	Implementation of Integrity Constraints and Views by Query Modification	1975	SIGMOD	0.00035719146
96	The Database Language GEM	1983	SIGMOD	0.00034286345
150	Making Smalltalk a Database System	1984	SIGMOD	0.00028930192
772	Data Abstraction, Views And Updates In Rigel	1979	SIGMOD	0.00014085842
1,126	Quel As A Data Type	1984	SIGMOD	0.00011920289
2,001	Data Constructors: On the Integration of Rules and Relations	1985	VLDB	9.2091743e-05
2,037	An Extensible Object-Oriented Approach to Databases for VLSI/CAD	1985	VLDB	9.1520092e-05
2,535	Database Portals: A New Application Program Interface	1984	VLDB	8.3333538e-05
2,752	An Implementation of Hypothetical Relations	1983	VLDB	8.0556787e-05
3,195	"Fill-in-the-Form" Programming	1985	VLDB	7.5467678e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	1,263	Don't be lazy, be consistent: Postgres-R, A new way to implement Database Replication	2000	VLDB
2	1,843	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,425	An Automated, Yet Interactive and Portable DB Designer	2010	SIGMOD
5	405	Distributed Query Processing In A Relational Data Base System	1978	SIGMOD
6	498	The Design of XPRS	1988	VLDB
7	4,221	Efficiently Supporting Procedures In Relational Database Systems	1987	SIGMOD
8	3,845	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