Search Postgresql Archives

data-checksums

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



--data-checksums
Use checksums on data pages to help detect corruption by the I/O system that would otherwise be silent. Enabling checksums may incur a noticeable performance penalty. This option can only be set during initialization, and cannot be changed later. 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 writer and/or during checkpoint.  Given that the process is async and application does not wait on it, is the performance penalty really a big concern.

thanks




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux