From PostgreSQL wiki
Jump to: navigation, search

This is a very draft version of the 9.2 Release announcement. Nothing in here is final and the quotes are not approved. This is posted here for the purposes of collaborative editing.

Draft 9.2 Release Announcement

SEPTEMBER 2012: The PostgreSQL Global Development Group announces the release of PostgreSQL 9.2. This release increases performance of the leading open source database in multiple ways, including improved vertical and horizontal scalability. New JSON support makes PostgreSQL more suitable for non-relational as well as relational workloads.

Improved Performance and Scalability

"With the release of PostgreSQL 9.2, the PostgreSQL Project has significantly advanced scalability and developer flexibility to provide our customers a highly performant database for their most demanding workloads," BIG USER #1 said. "We are especially happy with the addition of linear scalability to 64 cores, index-only scans and reductions in CPU power consumption."

Version 9.2 has multiple enhancements which gives users more options when scaling vertically, horizontally, or both, as well as improving performance for common single-server workloads. New features include:

  • Index-only scans, allowing users to avoid inefficient scans of base tables
  • Enhanced read-only workload scaling to 64 cores and over 300,000 queries per second
  • Improvements to data write speeds, including group commit
  • Reductions in CPU power consumption
  • Cascading replication, supporting geographically distributed standby databases

"COMPANY2 relies on Postgres for storing millions of sites and subscriptions. Solid and reliable for years," said SOME GUY, Founder of COMPANY2. "We're consistently on the bleeding edge (9.1 now, moving to 9.2 soon for the cascading replication alone) and it's been a pleasure since 8.4."

Developer-Friendly JSON Support

PostgreSQL 9.2 includes support for JSON data types and receiving query results in JSON. Combined with the new PL/v8 Javascript and PL/Coffee database programming extensions, and the optional HStore key-value store, users can now utilize PostgreSQL like a "NoSQL" document database, while retaining PostgreSQL's reliability, flexibility and performance.

"Native JSON support in PostgresSQL provides an efficient mechanism for creating and storing documents for web APIs. Often, front-end libraries like jQuery request tabular and tree-structured data, and this feature makes it convenient and provides performance advantages in casting records to JSON," said ANOTHER GUY, Senior Architect, SOME TELCO.