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.00049063803
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 6 of 106 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
13,347	Processing Object-Oriented Queries with Invertible Late Bound Functions	1995	VLDB	4.9605343e-05
13,433	Experiences With an Object Manager for a Process-Centered Environment	1992	VLDB	4.9605343e-05
13,444	Trait: An Attribute Management System for VLSI Design Objects	1991	SIGMOD	4.9605343e-05
13,475	Extending a Relational Database with Deferred Referential Integrity Checking and Intelligent Joins	1989	SIGMOD	4.9605343e-05
13,502	Rapid Application Prototyping: The PROQUEL Language	1988	VLDB	4.9605343e-05
13,534	Panel on Extensible Database Systems	1986	SIGMOD	4.9605343e-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.0019892478
8	The K-D-B-Tree: A Search Structure for Large Multidimensional Dynamic Indexes	1981	SIGMOD	0.00081207565
59	Differential Files: Their Application To The Maintenance Of Large Data Bases	1976	SIGMOD	0.00039478403
87	Implementation of Integrity Constraints and Views by Query Modification	1975	SIGMOD	0.00035589793
97	The Database Language GEM	1983	SIGMOD	0.00034172656
150	Making Smalltalk a Database System	1984	SIGMOD	0.00028835071
782	Data Abstraction, Views And Updates In Rigel	1979	SIGMOD	0.00014036612
1,130	Quel As A Data Type	1984	SIGMOD	0.00011879113
2,010	Data Constructors: On the Integration of Rules and Relations	1985	VLDB	9.1808661e-05
2,045	An Extensible Object-Oriented Approach to Databases for VLSI/CAD	1985	VLDB	9.1234027e-05
2,542	Database Portals: A New Application Program Interface	1984	VLDB	8.3020374e-05
2,760	An Implementation of Hypothetical Relations	1983	VLDB	8.0258643e-05
3,209	"Fill-in-the-Form" Programming	1985	VLDB	7.5183398e-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,853	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,451	An Automated, Yet Interactive and Portable DB Designer	2010	SIGMOD
5	407	Distributed Query Processing In A Relational Data Base System	1978	SIGMOD
6	500	The Design of XPRS	1988	VLDB
7	4,241	Efficiently Supporting Procedures In Relational Database Systems	1987	SIGMOD
8	3,854	Query Processing in Tertiary Memory Databases	1995	VLDB
9	1,144	The POSTGRES Data Model	1987	VLDB
10	101	The Design of the POSTGRES Storage System	1987	VLDB