PostgreSQL

[mehranFX]

PostgreSQL is a powerful, open source relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL92 and SQL99 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, Perl, Python, Ruby, Tcl, ODBC, among others




Limit Value
Maximum Database Size Unlimited
Maximum Table Size 32 TB
Maximum Row Size 1.6 TB
Maximum Field Size 1 GB
Maximum Rows per Table Unlimited
Maximum Columns per Table 250 - 1600 depending on column types
Maximum Indexes per Table Unlimited

[mehranFX]

BioPharm
Affymetrix
American Chemical Society
BASF, Agricultural Product Division (case study (http://www.postgresql.org/files/about/casestudies/wcgcasestudyonpostgresqlv1.2.pdf))
Institut de Biologie et Chimie des Proteines (article (http://biz.yahoo.com/prnews/060418/netu047.html?.v=18))
Genentech, Inc. (presentation (http://conferences.oreillynet.com/cs/os2004/view/e_sess/5336))
e-Commerce
CD Baby (article (http://www.oreillynet.com/pub/wlg/6286?wlg=yes))
Champion Products
Endpoint Corporation
Freeportway
FlightAware (podcast (http://bsdtalk.blogspot.com/2006/05/bsdtalk042-interview-with-karl.html))
RedSherriff (article (http://www.computerworld.com.au/index.php?id=1482975508))
Whitepages.com

Education
.LRN Project
Cognivity
Moscow State University, Moscow, Russia
Sternberg Astronomical Institute, Russia
Texas Cooperative Extension
University of Alabama, Birmingham (documentation (http://www.cis.uab.edu/it/postgresql-quickstart.php))
University of California, Berkeley
University of New South Wales
University of Oslo, Norway
University of Sydney
University of Western Sydney
Charles University in Prague, Czech Republic

Finance
Ameritrade
Journyx Timesheets
Logictree Systems
Trust-Commerce

Gaming
Perpetual Entertainment, Inc.
MobyGames

Government
City of Garden Grove, California (quote (http://www.postgresql.org/about/quotes.8))
The National Weather Service
Registre Francais des Emissions Polluantes
United Nations Children's Fund
United Nations Industrial Development Organisation
U.S. Agency for International Development
U.S. Centers For Disease Control and Prevention
U.S. Department of Labor
U.S. General Services Administration
U.S. State Department

Healthcare
CalorieKing.com
GnuMed (white-paper (http://www.gnumed.net/whitepapers/GNUMed_Database_Architecture.html))
Shannon Medical Center (white-paper (http://www.postgresql.org/about/casestudies/shannonmedical))

Manufacturing
eXo2.net Corp (presentation (http://techdocs.postgresql.org/oscon2005/aaron.thul/pg_built_your_car.pdf))
OpenMFG (article (http://www.networkworld.com/news/2005/090505-erp.html))

Media
Chicagocrime.org
Creative Commons
Greenpeace
Macworld
Penny Arcade
the451.com
The Washington Post U.S. Congress Votes Database

Open Source Projects
Bricolage
Debian
FreshPorts
FLPR (FreeBsd,LightHttpd,PostgreSQL,Ruby)
GForge
LAMP (Linux/Apache/Middleware(Perl,PHP,Python,Ruby)/PostgreSQL
OpenACS

Retail
ADP Dealer Services (article (http://informationweek.com/story/showArticle.jhtml?articleID=165702187))
Courage To Change
Tsutaya
The Rockport Company, LLC

Technology
Afilias (article (http://www.computerworld.com.au/index.php?id=760310963))
Apple (article (http://developer.apple.com/appleapplications/ardsql.html))
Fujitsu
Red Hat
Sirius IT
Sun Microsystems

Telecom
Cisco (documentation (http://www.cisco.com/en/US/products/sw/voicesw/ps4371/products_user_guide_chapter09186a00800c252c.html))
NTT Data
Optus
Rambler Internet Holdings
Skype
Telstra