Re: Checkpoint question

Поиск
Список
Период
Сортировка
От Qingqing Zhou
Тема Re: Checkpoint question
Дата
Msg-id Pine.LNX.4.58.0601112233270.6385@eon.cs
обсуждение исходный текст
Ответ на Re: Checkpoint question  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Qingqing Zhou
Дата:
Сообщение: Re: Checkpoint question
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Checkpoint question