Re: Initdb --data-checksums by default

Поиск
Список
Период
Сортировка
От Alex Ignatov
Тема Re: Initdb --data-checksums by default
Дата
Msg-id 57179AAF.5080502@postgrespro.ru
обсуждение исходный текст
Ответ на Re: Initdb --data-checksums by default  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-general

On 20.04.2016 16:58, Alvaro Herrera wrote:
> 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.
>
Right now i am working on this tests. On various media - hdd ssd ram and
some various workload. As soon as results be ready i'll provide my numbers

--
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: How do BEGIN/COMMIT/ABORT operate in a nested SPI query?
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: Enhancement Request