Jan Wieck wrote:
> Computing a checksum just before writing the block will NOT detect any

> faulty memory or Postgres bug that corrupted the block. You will have
> perfectly fine checksum over the corrupted data.
> A checksum only detects corruptions that happen between write and
> Most data corruptions that happen during that time however lead to
> sort of read error reported by the disk.

I have thought some more about it, and tend to agree now:
Checksums will only detect disk failure, and that's only
one of the many integrity problems that can happen.
And one that can be reduced to a reasonable degree with good
storage systems.

So the benefit of checksums is not enough to bother.

Laurenz Albe

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at


Reply via email to