From: | "Rakesh Kumar" <rakeshkumar464(at)mail(dot)com> |
---|---|
To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | data-checksums |
Date: | 2018-01-09 17:42:07 |
Message-ID: | trinity-a78f07c6-1bc0-4bd4-8cd7-2c52a7384eb1-1515519726939@3c-app-mailcom-lxa01 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
--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
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Frost | 2018-01-09 17:54:10 | Re: data-checksums |
Previous Message | Vincenzo Romano | 2018-01-09 17:25:03 | Re: How Many Partitions are Good Performing |