Re: Restartable Recovery

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Restartable Recovery
Дата
Msg-id 29986.1153061507@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Restartable Recovery  (Andreas Seltenreich <andreas+pg@gate450.dyndns.org>)
Ответы Re: Restartable Recovery  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-patches
Andreas Seltenreich <andreas+pg@gate450.dyndns.org> writes:
> Simon Riggs <simon@2ndquadrant.com> writes:
>> [2. text/x-patch; restartableRecovery.patch]

> Hmm, wouldn't you have to reboot the resource managers at each
> checkpoint? I'm afraid otherwise things like postponed page splits
> could get lost on restart from a later checkpoint.

Ouch.  That's a bit nasty.  You can't just apply a postponed split at
checkpoint time, because the WAL record could easily be somewhere after
the checkpoint, leading to duplicate insertions.  Right offhand I don't
see how to make this work :-(

            regards, tom lane

В списке pgsql-patches по дате отправления:

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: Have psql display names and OUT/INOUT in \df output
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Restartable Recovery