Re: Avoiding unnecessary reads in recovery

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas ADI SD
Тема Re: Avoiding unnecessary reads in recovery
Дата
Msg-id E1539E0ED7043848906A8FF995BDA57901F40487@m0143.s-mxs.net
обсуждение исходный текст
Ответ на Re: Avoiding unnecessary reads in recovery  (Jim Nasby <decibel@decibel.org>)
Список pgsql-hackers
> So what happens if a backend is running with full_page_writes
> = off, someone edits postgresql.conf to turns it on and
> forgets to reload/ restart, and then we crash? You'll come up
> in recovery mode thinking that f_p_w was turned on, when in
> fact it wasn't.
>
> ISTM that we need to somehow log what the status of
> full_page_writes is, if it's going to affect how recovery works.

Optimally recovery should do this when confronted with a full page image
only. The full page is in the same WAL record that first touches a page,
so this should not need to depend on a setting.

Andreas


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

Предыдущее
От: Michael Meskes
Дата:
Сообщение: Re: ECPG failure on BF member Vaquita (Windows Vista)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Avoiding unnecessary reads in recovery