Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group