On 8/28/2007 4:14 AM, Albe Laurenz wrote:
Not all databases are on enterprise scale storage systems, and
there's also the small possibility of PostgreSQL bugs that could
be detected that way.

Computing a checksum just before writing the block will NOT detect any faulty memory or Postgres bug that corrupted the block. You will have a perfectly fine checksum over the corrupted data.

A checksum only detects corruptions that happen between write and read. Most data corruptions that happen during that time however lead to some sort of read error reported by the disk.


# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== [EMAIL PROTECTED] #

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to