Re: Patch for fail-back without fresh backup

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Patch for fail-back without fresh backup
Дата
Msg-id CAM-w4HPNifdXnC0zvUui7C1Q0Rv6j98kR60NNrw3_rbTVRPU3w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Patch for fail-back without fresh backup  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Patch for fail-back without fresh backup  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Fri, Jun 14, 2013 at 2:21 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> So it's not that we actually need to log the individual hint bit
> changes, it's that we need to WAL-log a full page image on the first
> update after a checkpoint, so as to recover from torn-page cases.
> Which one are we doing?

Wal logging a full page image after a checkpoint wouldn't actually be
enough since subsequent hint bits will dirty the page and not wal log
anything creating a new torn page risk. FPI are only useful if all the
subsequent updates are wal logged.




-- 
greg



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Add visibility map information to pg_freespace.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Patch for fail-back without fresh backup