What is PostgreSQL?
PostgreSQL (pronounced "post-grey-sequel") is a sophisticated,
standards-based, Object-Relational database management system
(DBMS) supporting almost all SQL constructs, including
subselects, transactions, and user-defined types and functions.
Initially developed at the University of California at Berkely
in the late 1970s and early 1980s, PostgreSQL is, today, the
most advanced open-source database server in the world,
designed primarily for e-business and enterprise applications.
Why do people use PostgreSQL?
- SQL 92 compliant
- An enhancement of the Postgres DBMS, a next-generation
- Retains the powerful data model and rich data types of
Postgres while replacing the PostQuel query language with an
extended subset of SQL
- A very viable alternative to the market-leading proprietary
databases in terms of performance and scalability
- PostgreSQL has consistently performed an average of four to
five times faster than every other database in a variety of
tests administered by an independent technology solutions
- In benchmark tests, maintained a consistent output level
whether there were one or two simultaneous users
- PostgreSQL significantly outperformed both the leading
commercial and open-source applications in both speed and
PostgreSQL is free, and the complete source is available.