On Sun, 14 Aug 2011 07:15:00 -0600, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: > On Sun, Aug 14, 2011 at 6:51 AM, <tv@xxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
