PostgreSQL 9.2 Beta 版已经出来了，主要特性包括 Index-only scans，read-only 场景
强大的支撑 (300,000 queries per second)，写性能的改善，CPU资源消耗降低，以及 Cascading replication
等，有空可以测试下，下面是来自 PostgreSQL 官网 http://www.postgresql.org/about/news/1395/
The PostgreSQL Global Development Group announces the beta release of PostgreSQL 9.2,
which will include major increases in performance and both vertical and horizontal scalability.
The PostgreSQL Project asks all users to download and begin testing 9.2 Beta as soon as possible.
Major performance and scalability advances in this version include:
1 Index-only scans, allowing users to avoid inefficient scans of base tables
2 Enhanced read-only workload scaling to 64 cores and over 300,000 queries per second
3 Improvements to data write speeds, including group commit
4 Reductions in CPU power consumption
5 Cascading replication, supporting geographically distributed standby databases
PostgreSQL 9.2 will also offer many new features for application developers, including:
1 JSON data support, enabling hybrid document-relational databases
2 Range types, supporting new types of calendar, time-series and analytic applications
3 Multiple improvements to ALTER and other statements, easing runtime database updates
For a full listing of the features in version 9.2 Beta, please see the release notes.
We depend on our community to help test the next version in order to guarantee that it
is high-performance and bug-free. Please download PostgreSQL 9.2 Beta and try it with your
workloads and applications as soon as you can, and give feedback to the PostgreSQL developers.
More information on how to test and report issuesGet PostgreSQL 9.2 beta, including binaries
and installers for Windows, Linux and Mac from our download page.
Full documentation of the new version is available online, and also installs with PostgreSQL.
--PostgreSQL 9.2 beta 版源码下载地址