为什么80%的码农都做不了架构师?>>>
Major performance and scalability advances in this version include:Index-only scans, allowing users to avoid inefficient scans of base tables
参考:http://www.postgresql.org/about/news/1395/
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
PostgreSQL 9.2 will also offer many new features for application developers, including:JSON data support, enabling hybrid document-relational databases
Range types, supporting new tyJavascript:save_to_blog()pes of calendar, time-series and analytic applications
Multiple improvements to ALTER and other statements, easing runtime database updates