What’s New in PostgreSQL 9.1?

Analysis
Sep 12, 20112 mins

User-requested features shaped the latest PostgreSQL release.

“What this release really shows is that PostgreSQL is done playing catchup to the big proprietary database vendors, and is now innovating beyond them,” says Josh Berkus, PostgreSQL Core Team Member. “As Linux does for operating systems, we will be setting the targets for what features a relational database system should have,” he says.

postgresqllogo

PostgreSQL, the popular open source object-relational database system, started as Postgres at the University of California at Berkeley back in 1986. PostgreSQL 6.0 expanded out of academia into the open source world about ten years later. Released under the PostgreSQL License, PostgreSQL is supported by an active community and international user groups, and has an active IRC community. The database system runs on all major operating systems and has native programming interfaces for a variety of languages, including C/C++, Java, .Net, Perl, Python, Ruby.

Released today, PostgreSQL 9.1 adds support for foreign tables, per-column collation support, K-Nearest-Neighbor Indexing, and adds extensions that simplify packaging of additions to PostgreSQL. A full list of major enhancements is available in the release notes.

“The feature that users are the most excited about is Synchronous Replication,” Berkus says. Synchronous replication allows users to confirm that all changes made by a transaction have been transferred to a synchronous standby server.

Download the latest release at: https://www.postgresql.org/download/