On Sun, 14 Aug 2011 07:15:00 -0600, Scott Marlowe <[email protected]> wrote: > On Sun, Aug 14, 2011 at 6:51 AM, <[email protected]> wrote: >> >> I've increased the test duration to 10 minutes, decreased the >> checkpoint timeout to 4 minutes and a checkpoint is issued just before >> the pgbench. That way the starting position should be more or less the >> same for all runs. > > Also look at increasing checkpoint completion target to something > closer to 1. 0.8 is a nice starting place.
Yes, I've increased that already: checkpoints_segments=64 checkpoints_completion_target=0.9 Tomas -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
