On Sun, 14 Aug 2011 07:15:00 -0600, Scott Marlowe
> 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:
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2011-08-14 17:33:44|
|Subject: Re: strange pgbench results (as if blocked at the end) |
|Previous:||From: Scott Marlowe||Date: 2011-08-14 13:15:00|
|Subject: Re: strange pgbench results (as if blocked at the end)|