On Sun, 14 Aug 2011 07:15:00 -0600, Scott Marlowe <scott.marl...@gmail.com> wrote: > On Sun, Aug 14, 2011 at 6:51 AM, <t...@fuzzy.cz> 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 (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance