data-checksums

Поиск
Список
Период
Сортировка
От Rakesh Kumar
Тема data-checksums
Дата
Msg-id trinity-a78f07c6-1bc0-4bd4-8cd7-2c52a7384eb1-1515519726939@3c-app-mailcom-lxa01
обсуждение исходный текст
Ответы Re: data-checksums  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-general
--data-checksums
Use checksums on data pages to help detect corruption by the I/O system that would otherwise be silent. Enabling
checksumsmay incur a noticeable performance penalty. This option can only be set during initialization, and cannot be
changedlater. If set, checksums are calculated for all objects, in all databases.
 
====

If I understand it correctly, the performance penalty is when the blocks are written to the disk by the background
writerand/or during checkpoint.  Given that the process is async and application does not wait on it, is the
performancepenalty really a big concern.
 

thanks


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

Предыдущее
От: Vincenzo Romano
Дата:
Сообщение: Re: How Many Partitions are Good Performing
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: data-checksums