Re: Checkpoint question - Mailing list pgsql-hackers

From Qingqing Zhou
Subject Re: Checkpoint question
Date
Msg-id Pine.LNX.4.58.0601112233270.6385@eon.cs
Whole thread Raw
In response to Re: Checkpoint question  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers

On Wed, 11 Jan 2006, Tom Lane wrote:

>
> It'd be possible to do something like this: after establishing
> RedoRecPtr, make one quick pass through the buffers and make a list of
> what needs to be dumped at that instant.  Then go back and do the actual
> I/O for only those buffers.  I'm dubious that this will really improve
> matters though, as the net effect is just to postpone I/O that will
> happen anyway soon after the checkpoint (as soon as the bgwriter goes
> back to normal activity).
>

We could extend the grammar to CHECKPOINT [FULL/PARTIAL] to let the user
decide what to do. If PARTIAL, an important reason is for fast recovery.

Regards,
Qingqing


pgsql-hackers by date:

Previous
From: Qingqing Zhou
Date:
Subject: Re: Checkpoint question
Next
From: Simon Riggs
Date:
Subject: Re: Checkpoint question