On Sun, 14 Aug 2011 07:15:00 -0600, Scott Marlowe
<scott(dot)marlowe(at)gmail(dot)com> wrote:
> On Sun, Aug 14, 2011 at 6:51 AM, <tv(at)fuzzy(dot)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