Checksums and full_page_writes

Поиск
Список
Период
Сортировка
От Borodin Vladimir
Тема Checksums and full_page_writes
Дата
Msg-id EC425466-3226-48D2-B7BE-D9E223CE91E7@simply.name
обсуждение исходный текст
Ответы Re: Checksums and full_page_writes  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-general
Hi all.

I’ve read thread [0], src/backend/storage/page/README and everything I found in the documentation about checksums [1, 2] but I haven’t understood what is my risk if I enable checksums during initdb and turn off full_page_writes?

Am I right that I can get torn pages on disk in that case but I will somehow know about it during checksum checking when this page will be read from disk to shared buffers? And is there any way to recover such torn page (from replica or backup+archived logs, for example)?

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Check constraint on foreign table using SQL function
Следующее
От: Sameer Kumar
Дата:
Сообщение: Re: help troubleshooting invalid page header error