HEADER : The latest major version of PostgreSQL has so many innovations and improvements ! We really struggled to choose the ten most disruptive features and showcase each of them, with a step-by-step example. Let's see what PostgreSQL 9.1 is gonna change for your data severs !


In September 2011, The PostgreSQL Global Development Group released PostgreSQL 9.1. This latest version of the leading open source database offers innovative technology, unmatched extensibility, and new features.

SUBHEADER : Responding to Users

Version 9.1 delivers several features which users have been requesting for years, removing roadblocks to deploying new or ported applications on PostgreSQL. These include Synchronous Replication, Per-Column Collations and Unlogged Tables.

SUBHEADER : Advancing the State of the Art

As always the PostgreSQL community innovates with cutting-edge features ! Version 9.1 includes 4 items which are new to the database industry, such as: K-Nearest-Neighbor Indexing, Serializable Snapshot Isolation, Writeable Common Table Expressions and Security-Enhanced Postgres.

SUBHEADER: Extending the Database Engine

PostgreSQL's extensibility enables users to add new functionality to a running production database, and use them for tasks no other database system can perform. Version 9.1 adds new extensibility tools, including: SQL/MED support, Extensions and the PGXN network.

In PostgreSQL's 25th year of database development, the community continues to advance database technology with every annual release !

QUOTE 1 : “PostgreSQL 9.1 provides some of the most advanced enterprise capabilities of any open source database, and is backed by a vibrant and innovative community with proven customer success. PostgreSQL is well positioned for building and running applications in the cloud.” Charles Fan, Sr. VP R&D, VMware

BOX 1 TITLE: Check out the wiki

BOX 1 TEXT: This article is heavily based on the wiki page called “What's new in PostgreSQL 9.1 ?”.


BOX 2 TITLE: Marc Cousin

BOX 2 IMAGE: dscf2009.jpg

BOX 2 TEXT: Marc Cousin is a PostgreSQL and Oracle DBA since 1999. He is involved in the Postgres community in various ways, providing help on the French-speaking forum or participating to the PG Day France. He works at Dalibo as a Senior DBA.


SQL/MED 16 Per column collation 16 Unlogged tables 17 Sync. replication 18 Extensions 19 KNN Index 20 PGXN 21 SE Postgres 22 SSI 23 Writeable CTE 24