Re: Checkpoint question - Mailing list pgsql-hackers

From Qingqing Zhou
Subject Re: Checkpoint question
Date
Msg-id Pine.LNX.4.58.0601120421290.10946@eon.cs
Whole thread Raw
In response to Re: Checkpoint question  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Checkpoint question  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-hackers

On Thu, 12 Jan 2006, Simon Riggs wrote:
>
> The only buffers this will miss are ones that were clean throughout the
> whole of the last checkpoint cycle, yet have been dirtied between the
> start of the checkpoint pass and when the pass reaches it.

I agree on the analysis but I am not sure current interval of doing a
checkpoint. So it depends. If the checkpoint on an io-intensive machine
the interval I guess would not be small. Also, in this environment, one
more round of lock cycle should be relatively cheap. But we currently
don't have any numbers on hand ...

Regards,
Qingqing




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Checkpoint question
Next
From: "Alon Goldshuv"
Date:
Subject: Re: Libpq COPY optimization