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)
Institut de Biologie et Chimie des Proteines (article)
Genentech, Inc. (presentation)
e-Commerce
CD Baby (article)
Champion Products
Endpoint Corporation
Freeportway
FlightAware (podcast)
RedSherriff (article)
Whitepages.com

Education
.LRN Project
Cognivity
Moscow State University, Moscow, Russia
Sternberg Astronomical Institute, Russia
Texas Cooperative Extension
University of Alabama, Birmingham (documentation)
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)
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)
Shannon Medical Center (white-paper)

Manufacturing
eXo2.net Corp (presentation)
OpenMFG (article)

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)
Courage To Change
Tsutaya
The Rockport Company, LLC

Technology
Afilias (article)
Apple (article)
Fujitsu
Red Hat
Sirius IT
Sun Microsystems

Telecom
Cisco (documentation)
NTT Data
Optus
Rambler Internet Holdings
Skype
Telstra