PostgreSQL 9.5 Alpha 1 版发布，这速度比我预期要快，在正式发布前有些特性会做调整，但主要包括以下特性：

Major Features

Among new major features available for testing in this alpha are:

• Block-Range Indexes (BRIN) which enable compact indexing of very large tables
• Large speed improvements in in-memory sorting and hashing
• Automated management of transaction log size
• INSERT ON CONFLICT UPDATE, otherwise known as “UPSERT”
• Grouping Sets, CUBE and ROLLUP analytic operations
• Row-Level Security (RLS) support
• More JSONB data manipulation functions and operators
• Added the pg_rewind tool and other high availability improvements to replication
• Multiple enhancements to Foreign Data Wrappers, including IMPORT FOREIGN SCHEMA
• Large increases in multi-core and large memory scalability

详见： http://www.postgresql.org/about/news/1595/

有空时研究下 9.5 的新特性。