Postgres Pro
Downloads
Home   >   mailing lists

Re: strange pgbench results (as if blocked at the end) - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: strange pgbench results (as if blocked at the end)
Date
Msg-id CAOR=d=1WFDK1-9Trsqw6_aUUu-3dSRs03QS-PbnnovaLDZ0WzQ@mail.gmail.com
Whole thread Raw
In response to Re: strange pgbench results (as if blocked at the end)  (<tv@fuzzy.cz>)
Responses Re: strange pgbench results (as if blocked at the end)
List pgsql-performance
Tree view 
On Sun, Aug 14, 2011 at 6:51 AM,  <tv@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.

pgsql-performance by date:

Previous
From:
Date:
Subject: Re: strange pgbench results (as if blocked at the end)
Next
From:
Date:
Subject: Re: strange pgbench results (as if blocked at the end)