Re: Initdb --data-checksums by default

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: Initdb --data-checksums by default
Дата
Msg-id 57176AAC.7080703@hogranch.com
обсуждение исходный текст
Ответ на Re: Initdb --data-checksums by default  (Alex Ignatov <a.ignatov@postgrespro.ru>)
Список pgsql-general
On 4/20/2016 1:00 AM, Alex Ignatov wrote:
Uncorrectable read error rate ~ 10^-15- 10^-14. This error stays undetected and uncorrectable.

what are your units here?   disk IO is done by blocks, and the CRCs and trellis codes used by the disk drives for error detection and correction are applied on a whole block basis.

so is that one undetected error per 10^-14 blocks read, or what?

and what about file systems like ZFS that already do their own CRC ?


-- 
john r pierce, recycling bits in santa cruz

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

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