Greetings, * Rakesh Kumar (rakeshkumar...@mail.com) wrote: > --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.
There's also a hit when pages are read back in, since we need to calculate the checksum and verify it hasn't changed. That said, imv anyway, the performance hit is small and having checksums is well worth it. Thanks! Stephen
signature.asc
Description: PGP signature
