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

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

From: <tv(at)fuzzy(dot)cz>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: strange pgbench results (as if blocked at the end)
Date: 2011-08-14 14:10:01
Message-ID: 37b2e83f52518f7e9bf01bcc97b622bf@mail.gransy.com (view raw or flat)
Thread:
Lists: pgsql-performance
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

In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2011-08-14 17:33:44
Subject: Re: strange pgbench results (as if blocked at the end)
Previous:From: Scott MarloweDate: 2011-08-14 13:15:00
Subject: Re: strange pgbench results (as if blocked at the end)

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