PostgreSQL is a highly-scalable, SQL compliant, open source object-relational database management system. With more than 15 years of development history, it is quickly becoming the de facto database for enterprise level open source solutions.
PostgreSQL is an object-relational database management system (ORDBMS) based on POSTGRES, Version 4.2, developed at the University of California at Berkeley Computer Science Department. POSTGRES pioneered many concepts that only became available in some commercial database systems much later.
PostgreSQL is an open-source descendant of this original Berkeley code. PostgreSQL supports SQL92 and SQL99.
Here are some key features of "PostgreSQL":
· complex queries
· foreign keys
· triggers
· views
· transactional integrity
· multiversion concurrency control
Additionally, PostgreSQL can be extended by the user in many ways, for example by adding new:
· data types
· functions
· operators
· aggregate functions
· index methods
· procedural languages
And because of the liberal license, PostgreSQL can be used, modified, and distributed by everyone free of charge for any purpose, be it private, commercial, or academic.
Product's homepage
What's New in This Release: [ read full changelog ]
· fix build issues on HP-UX and Itanium
· update time zone files for recent time zone changes
· change SQLSTATE for Hot Standby warnings
· prevent bgwriter hang during recovery
· prevent recursive composite type creation
· disallow dropping tables whose triggers are still pending
· allow use of "replication" as a user name
· prevent a crash during GEQO planning
· improve join plans for tables with missing statistics
· fix error with SELECT FOR UPDATE in a subselect
· close PL/python array slice memory leak
· allow SSL connections for users with no home directory
· allow building PostgreSQL 9.0 with 64-bit MinGW
Find us on Google+
