Re: PATCH: regular logging of checkpoint progress - Mailing list pgsql-hackers

From Tomas Vondra
Subject Re: PATCH: regular logging of checkpoint progress
Date
Msg-id 240e9c7a3e0deb664908c4bd07a4a01e.squirrel@sq.gransy.com
Whole thread Raw
In response to Re: PATCH: regular logging of checkpoint progress  (Noah Misch <noah@2ndQuadrant.com>)
Responses Re: PATCH: regular logging of checkpoint progress
List pgsql-hackers
On 27 Srpen 2011, 6:01, Noah Misch wrote:
> On Fri, Aug 26, 2011 at 10:46:33AM +0200, Tomas Vondra wrote:
>> 1. collect pg_stat_bgwriter stats
>> 2. run pgbench for 10 minutes
>> 3. collect pg_stat_bgwriter stats (to compute difference with (1))
>> 4. kill the postmaster
>>
>> The problem is that when checkpoint stats are collected, there might be
>> a
>> checkpoint in progress and in that case the stats are incomplete. In
>> some
>> cases (especially with very small db blocks) this has significant impact
>> because the checkpoints are less frequent.
>
> Could you remove this hazard by adding a step "2a. psql -c CHECKPOINT"?

I already do that, but it really does not solve the issue. It just aligns
the first expected 'timed' checkpoint, it does not solve the problem with
in-progress checkpoints unless the runs behave exactly the same (and
that's the boring case).

Tomas



pgsql-hackers by date:

Previous
From: Jeff MacDonald
Date:
Subject: Re: Inputting relative datetimes
Next
From: Peter Eisentraut
Date:
Subject: Re: [COMMITTERS] pgsql: Avoid locale dependency in expected output.