PostgreSQL 9.1 Press Kit

Contents

  Text of Original Release
  Details of Features
  25 Years of Database Innovation
  Where to Download
  Documentation
  License
  Contacts
  Full Text of Quotes and Company Information
  Corporate Support

Original Press Release

12 SEPTEMBER 2011: The PostgreSQL Global Development Group announces the release of PostgreSQL 9.1. This latest version of the leading open source database offers innovative technology, unmatched extensibility, and new features such as synchronous replication, K-Nearest Neighbor indexing, and foreign data wrappers.

"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," said Charles Fan, Sr. VP R&D, VMware.

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: enable high-availability with consistency across multiple servers
  • Per-Column Collations: support linguistically-correct sorting per database, table or column.
  • Unlogged Tables: greatly improves performance for ephemeral data

"Heroku runs the largest PostgreSQL database-as-a-service in the world," said James Lindenbaum, Heroku co-founder. "The release of synchronous data replication with 9.1 provides our customers with innovative new ways of protecting mission-critical data, and validates PostgreSQL as one of the fastest-moving datastores available."

Advancing the State of the Art

Our community of contributors innovates with cutting-edge features. Version 9.1 includes several which are new to the database industry, such as:

  • K-Nearest-Neighbor Indexing: index on "distance" for faster location and text-search queries
  • Serializable Snapshot Isolation: keeps concurrent transactions consistent without blocking, using "true serializability"
  • Writeable Common Table Expressions: execute complex multi-stage data updates in a single query
  • Security-Enhanced Postgres: deploy military-grade security and Mandatory Access Control

"OpenERP has always relied on the enterprise-class features of PostgreSQL to provide a fast, reliable and scalable foundation for the Business Applications supporting our customers' operations every day. Data integrity in highly concurrent and transactional contexts is a critical topic for us, and we're very enthusiastic about the new Serializable Snapshot Isolation of PostgreSQL 9.1!" said Olivier Dony, OpenERP Community Manager.

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:

  • Foreign Data Wrappers: attach and query other databases from PostgreSQL
  • Extensions: easily create, load, and manage new database features

All of the above features, and more, are detailed on the What's New In 9.1 wiki page, as well as our release notes.

In PostgreSQL's 25th year of database development, our community continues to advance database technology with every annual release. Download version 9.1 now and experience the most advanced open source database system in the world.

About PostgreSQL: PostgreSQL is the leading open source database system, with a global community of thousands of users and contributors and dozens of companies and organizations. The PostgreSQL Project builds on 25 years of engineering, starting at the University of California, Berkeley, and has an unmatched pace of development today. PostgreSQL's mature feature set not only matches top proprietary database systems, but exceeds them in advanced database features, extensibility, security and stability. Learn more about PostgreSQL and participate in our community at http://www.postgresql.org.

Extended Release Information

Details of Features

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 for Clustering:
Enable high-availability with consistency across multiple nodes, by deploying PostgreSQL clusters using synchronous replication. Synchronous replication supports "2-safe replication" which ensures transactions have been confirmed by a standby server in addition to the master, greatly limiting the possibility of data loss. Only PostgreSQL has transaction-level synchronous replication, allowing users to choose per transaction between response time and data safety.
Per-column Collations for Multi-lingual Databases:
Users can now set the collation for strings on a single column. This permits true multilingual databases, where each text column is a different language, and indexes and sorts correctly for that language.
Unlogged Tables to Improve Performance:
When performance is more important than durability, unlogged tables provide a way to improve performance while keeping the data managed within PostgreSQL. Removing logging reduces I/O overhead, yielding performance improvements up to 10 times faster when compared to logged tables. Scenarios expected to leverage unlogged tables include web session data, real time logging, ETL and temporary/intermediate tables for functions.

Advancing the State of the Art

Our community is innovating, delivering cutting-edge features which are new to the database industry. Some of these features are only available on PostgreSQL.

Powerful Similarity Searches with K-Nearest-Neighbor (KNN) Indexing:
Create new applications using PostgreSQL KNN-GiST indexes, which provide innovative indexing to avoid expensive table scans. KNN enhances PostgreSQL's query capabilities by using mathematical "distance" for indexing and searches. These indexes can be used to enhance common text searches, text-similarity searches, geospatial location comparisons and other queries. Example searches that took 2 seconds without the index returned in 20 ms with this feature. Text search indexes can be also now be configured to provide indexing support for LIKE '%string%' queries without changing any SQL. PostgreSQL is among the first database systems to have KNN.
Serializable Snapshot Isolation:
Allows users to enforce arbitrarily complex user-defined business rules within the database without blocking, by automatically detecting live race conditions in your SQL transactions at runtime. This feature currently exists only in PostgreSQL.
Writeable Common Table Expressions (wCTE):
Supports the relational integrity of your data by allowing you to update multiple, cascading, related records in a single statement. By using the results of one query to execute another query, you can update recursively, hierarchically, across foreign keys, or even more creatively. PostgreSQL provides the most complete and flexible implementation of this SQL feature available.
Security-Enhanced Postgres (SE-Postgres):
Deploy military-grade security and mandatory access control with full-integration support for Security-Enhanced Linux (SE-Linux). SE-Linux is a NSA project that modifies the Linux kernel with security-related functions. It has been endorsed by and included with major Linux distributions including, but not limited to, Red Hat, CentOS, Debian and Ubuntu. PostgreSQL is the only database system which has tight integration with SE-Linux.

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 critical new extensibility features, including:

Foreign Data Wrappers (FDW):
As part of our standards-compliant SQL/MED support for querying data outside the PostgreSQL database, FDWs allow users to create "drivers" and attach external data sources, which can be used as read-only tables. FDWs make PostgreSQL a powerful tool for enterprise data integration, and they make migration easier. FDWs initially available from the community include comma-separated-value (CSV) files, Oracle, MySQL, CouchDB, and even Twitter sources. And many more are expected in the near future.
Extensions:
While PostgreSQL has always been extensible, now users can easily create, load, upgrade, and manage any of dozens of database extensions using the EXTENSION database object. The new site PGXN.org offers a repository for contributing and downloading extensions.

For explanations of these features and others, please see the following resources:

25 Years of Database Innovation

The POSTGRES project was inaugurated at the University of California, Berkeley, in June 1986 with the publication of the original POSTGRES design by Lawrence A. Rowe and Michael R. Stonebraker. In the 25 years since then, POSTGRES became an open source project, converted to using SQL, changed its name to PostgreSQL, and became one of the leading relational databases. Today, our community competes with some of the largest software companies in the world to deliver new database functionality and better performance.

There have been 23 releases of POSTGRES and PostgreSQL, including version 9.1. PostgreSQL is the only major SQL database system to have consistent, featureful releases every year.

Downloads

Documentation

HTML documentation and man pages are installed with PostgreSQL, but feel free to browse, search and comment on our extensive, interactive online documentation.

License

PostgreSQL uses the PostgreSQL License, a BSD-like license which only requires that the licensed source code maintain its copyright and licensing information. This OSI-certified license is widely appreciated as flexible and business-friendly, since it does not restrict the use of PostgreSQL with commercial and proprietary applications. Together with multi-company support and public ownership of the code, our license makes PostgreSQL very popular with vendors wanting to embed a database in their own products without fear of fees, vendor lock-in, or changes in licensing terms.

Contacts

Web Pages

Press Inquiries

USA and General Inquries
PostgreSQL PR Team
press@postgresql.org
+1 347-6-PGSQL-9 (or +1-347-674-7759)

Ireland
Raymond O'Donnell
ie@postgresql.org
+353 (0)87 2241365

United Kingdom
Simon Riggs
uk@postgresql.org
+44-7900-255520

Full Text of Quotes and Company Information

"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," said Charles Fan, Sr. VP R&D, VMware.

About VMWare: VMware (NYSE:VMW), the global leader in virtualization and cloud infrastructure, delivers customer-proven solutions that accelerate IT by reducing complexity and enabling more flexible, agile service delivery. VMware enables enterprises to adopt a cloud model that addresses their unique business challenges. VMware's approach accelerates the transition to cloud computing while preserving existing investments and improving security and control. With more than 250,000 customers and 25,000 partners, VMware solutions help organizations of all sizes lower costs, increase business agility and ensure freedom of choice. Contact: VMWare PR or phone +1 (650) 427-2485

"Heroku runs the largest PostgreSQL database-as-a-service in the world," said James Lindenbaum, Heroku co-founder. "The release of synchronous data replication with 9.1 provides our customers with innovative new ways of protecting mission-critical data, and validates PostgreSQL as one of the fastest-moving datastores available."

About Heroku: Heroku is the leading open platform as a service (PaaS) focused on ease of use, automation, and reliability. Headquartered in San Francisco, CA, Heroku is a passionate and active supporter of Ruby technologies and cloud architecture. Heroku was recently named to the "Dow Jones FASTech 50 Start-ups to Watch" list, recognized as a Gartner "Cool Vendor in Application Platforms as a Service" in April 2010, named to the Always OnDemand Top 100 Private Companies, and recognized as a "Best Products of 2009" and "Best Platform of 2010" by ReadWriteWeb. In April 2011, Heroku was named #2 on its annual list of "Best Places to Work" in the Bay Area by the San Francisco Business Times. For more information, please visit our web page and our blog or follow Heroku on Twitter. Heroku is a wholly owned subsidiary of salesforce.com. Contact: Jill Ratkevic

"OpenERP has always relied on the enterprise-class features of PostgreSQL to provide a fast, reliable and scalable foundation for the Business Applications supporting our customers' operations every day. Data integrity in highly concurrent and transactional contexts is a critical topic for us, and we're very enthusiastic about the new Serializable Snapshot Isolation of PosgtreSQL 9.1! Synchronous replication and more performance optimizations are two other reasons we are looking forward to the next release of PostgreSQL, truly the epitome of Open Source software," said Olivier Dony, OpenERP Community Manager.

About OpenERP: OpenERP S.A. is the editor of OpenERP, a comprehensive Open Source Business Application Suite, including CRM, Sales, Accounting, Project Management, Warehouse Management, Manufacturing, Human Resources, and more. Founded in 2005 by CEO Fabien Pinckaers, OpenERP thrives in a unique ecosystem combining the resources of its community, partner network and editor. The community (1500 active members as of August 2011) contributes every day to the enrichment of OpenERP. The network of partners, established in more than 65 countries, deploys the solution locally. Also available as an online service (SaaS), OpenERP is one of the most installed business suites worldwide (1,000 downloads/day). Media Contact: Nicoleta Gherlea +32-2-290-34-90

Corporate Support

PostgreSQL enjoys the support of numerous companies, who sponsor developers, provide hosting resources, and give us financial support. The largest long-term sponsors are listed on our development sponsors page.

There is also a large community of companies offering PostgreSQL Support, from individual consultants to multinational companies.

Donations gladly accepted.