Re: Initdb --data-checksums by default

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Initdb --data-checksums by default
Дата
Msg-id 20160420135808.GA855511@alvherre.pgsql
обсуждение исходный текст
Ответ на Initdb --data-checksums by default  (Alex Ignatov <a.ignatov@postgrespro.ru>)
Ответы Re: Initdb --data-checksums by default  (Alex Ignatov <a.ignatov@postgrespro.ru>)
Список pgsql-general
Alex Ignatov wrote:
> Hello everyone!
> Today in Big Data epoch silent data corruption becoming more and more issue
> to afraid of. With uncorrectable read error rate ~ 10^-15  on multiterabyte
> disk bit rot is the real issue.
> I think that today checksumming data  must be mandatory  set by default.
> Only if someone doesn't care about his data he can manually turn this option
> off.

In principle I support the idea of turning data checksums by default,
but can you provide some numbers on how it affects performance on
various workloads?  That's a critical point in the discussion.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Initdb --data-checksums by default
Следующее
От:
Дата:
Сообщение: Re: How do BEGIN/COMMIT/ABORT operate in a nested SPI query?