POSTGRES

OVERVIEW

This document is taken from the reference manual for the POSTGRES database management system under development at the University of California at Berkeley. The POSTGRES project, led by Professor Michael Stonebraker, is sponsored by the Defense Advanced Research Projects Agency (DARPA), the Army Research Office (ARO), the National Science Foundation (NSF), and ESL, Inc. POSTGRES is distributed in source code format and is the property of the Regents of the University of California. However, the University will grant unlimited commercialization rights for any derived work on the condition that it obtain an educational license to the derived work. For further information, consult the Berkeley Campus Software Office, 295 Evans Hall, University of California, Berkeley, CA 94720. Note that there is no organization who can help you with any bugs you may encounter or with any other problems. In other words, this is unsupported software.

POSTGRES DISTRIBUTION

This reference describes Version 4.1 of POSTGRES. The POSTGRES software is about 200,000 lines of C code. Information on obtaining the source code is available from:
Claire Mosher
Computer Science Division
521 Evans Hall
University of California
Berkeley, CA 94720
(510) 642-4662
Version 4.1 has been tuned modestly. Hence, on the Wisconsin benchmark, one should expect performance about twice that of the public domain, University of California version of INGRES, a relational prototype from the late 1970s. As distributed, POSTGRES runs on Digital Equipment Corporation computers based on MIPS R2000 and R3000 processors (under Ultrix 4.2 and 4.3) and Sun Microsystems computers based on SPARC processors (under SunOS 4.1). Work is underway to support Digital Equipment Corporation computers based on Alpha AXP (DECchip 21064) processors (under OSF/1) and Hewlett-Packard computers based on PA-RISC processors (under HP-UX).

ACKNOWLEDGEMENTS

POSTGRES has been constructed by a team of undergraduate, graduate, and staff programmers. The contributors (in alphabetical order) consisted of: Jeff Anton, Paul Aoki, James Bell, Jennifer Caetta, Philip Chang, Jolly Chen, Ron Choi, Bob Devine, Matt Dillon, Zelaine Fong, Adam Glass, Jeffrey Goh, Steven Grady, Serge Granik, Marti Hearst, Joey Hellerstein, Michael Hirohama, Chin-heng Hong, Wei Hong, Anant Jhingran, Greg Kem- nitz, Case Larsen, Jeff Meredith, Michael Olson, Nels Olson, Lay-Peng Ong, Carol Paxson, Avi Pfeffer, Spyros Potamianos, Sunita Sarawagi, David Muir Sharnoff, Cimarron Taylor, Yongdong Wang, Kristin Wright and Andrew Yu. Marc Teitelbaum served as chief programmer for Version 4.1 and was responsible for overall coordination of the project. This reference was collectively written by the above implementation team, assisted by Michael Stonebraker, Chandra Ghosh and Claire Mosher.
This text is part of the POSTGRES Reference Manual