Re: Checkpoint question

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