From: tv@fuzzy.cz
To: pgsql-performance@postgresql.org
Subject: Re: strange pgbench results (as if blocked at the end)
Date: Sun, 14 Aug 2011 16:10:01 +0200
Message-ID: <37b2e83f52518f7e9bf01bcc97b622bf@mail.gransy.com> (raw)
In-Reply-To: <CAOR=d=1WFDK1-9Trsqw6_aUUu-3dSRs03QS-PbnnovaLDZ0WzQ@mail.gmail.com>
References: <2f9ba8ed6e4ed11d9a6d236cb4d2a2ec.squirrel@sq.gransy.com>
<4E45EAD3.9030102@2ndQuadrant.com>
<bdf03aa0550140de6491b3ce6d3eebd4@mail.gransy.com>
<CAOR=d=1WFDK1-9Trsqw6_aUUu-3dSRs03QS-PbnnovaLDZ0WzQ@mail.gmail.com>
On Sun, 14 Aug 2011 07:15:00 -0600, Scott Marlowe
<scott.marlowe@gmail.com> wrote:
> 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.
Yes, I've increased that already:
checkpoints_segments=64
checkpoints_completion_target=0.9
Tomas
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tv@fuzzy.cz
Subject: Re: strange pgbench results (as if blocked at the end)
In-Reply-To: <37b2e83f52518f7e9bf01bcc97b622bf@mail.gransy.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox