On 6 May 2012 21:19, Joshua Berkus <josh@agliodbs.com> wrote:
> Major performance and scalability advances ready to be tested in this version include:
Sounds good, thanks for taking the time to write that.
> * Index-only scans, allowing users to avoid expensive scans of slow-changing base tables
slow changing, yes, but also insert mostly tables is a very important case
> * Dramatially improved read-only workload scaling to 64 cores and over 300,000 queries per second
the write rate changes are very important also, need to mention those
> * Cascading replication, supporting rapid failover and geographically distributed standby databases
"rapid failover" code was not committed
there's no mention of
* Group Commit improvements
* Power reduction improvements - greatly reduced cost and reduced
environmental impact of running Postgres in virtual and cloud
environments
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services