On Tue, Feb 14, 2012 at 6:45 PM, Greg Smith <greg@2ndquadrant.com> wrote:
> Minimal changes were made to the postgresql.conf. shared_buffers=2GB,
> checkpoint_segments=64, and I left wal_buffers at its default so that 9.1
> got credit for that going up. See
> http://highperfpostgres.com/results-write-9.2-cf4/541/pg_settings.txt for a
> full list of changes, drive mount options, and important kernel settings.
> Much of that data wasn't collected in last year's pgbench-tools runs.
Please retest with wal_buffers 128MB, checkpoint_segments 1024
Best to remove any tunable resource bottlenecks before we attempt
further analysis.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services