Re: strange pgbench results (as if blocked at the end)

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: tv(at)fuzzy(dot)cz
Cc: Greg Smith <greg(at)2ndquadrant(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: strange pgbench results (as if blocked at the end)
Date: 2011-08-14 13:15:00
Message-ID: CAOR=d=1WFDK1-9Trsqw6_aUUu-3dSRs03QS-PbnnovaLDZ0WzQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message tv 2011-08-14 14:10:01 Re: strange pgbench results (as if blocked at the end)
Previous Message tv 2011-08-14 12:51:37 Re: strange pgbench results (as if blocked at the end)