Re: Offline enabling/disabling of data checksums

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Offline enabling/disabling of data checksums
Дата
Msg-id 20190313101021.GF2988@paquier.xyz
обсуждение исходный текст
Ответ на Re: Offline enabling/disabling of data checksums  (Fabien COELHO <coelho@cri.ensmp.fr>)
Ответы Re: Offline enabling/disabling of data checksums
Re: Offline enabling/disabling of data checksums
Список pgsql-hackers
On Wed, Mar 13, 2019 at 10:44:03AM +0100, Fabien COELHO wrote:
> Yep. That is the issue I think is preventable by fsyncing updated data
> *then* writing & syncing the control file, and that should be done by
> pg_checksums.

Well, pg_rewind works similarly: control file gets updated and then
the whole data directory gets flushed.  In my opinion, the take here
is that we log something after the sync of the whole data folder is
done, so as in the event of a crash an operator can make sure that
everything has happened.
--
Michael

Вложения

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

Предыдущее
От: Tomas Vondra
Дата:
Сообщение: Re: Compressed TOAST Slicing
Следующее
От: "Imai, Yoshikazu"
Дата:
Сообщение: RE: speeding up planning with partitions