Skip site navigation (1) Skip section navigation (2)

Re: Block-level CRC checks

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Paul Schlie <schlie(at)comcast(dot)net>
Cc: Brian Hurt <bhurt(at)janestcapital(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Block-level CRC checks
Date: 2008-10-01 15:56:30
Message-ID: 23549.1222876590@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Paul Schlie <schlie(at)comcast(dot)net> writes:
> - yes, if you're willing to compute true CRC's as opposed to simpler
> checksums, which may be worth the price if in fact many/most data
> check failures are truly caused by single bit errors somewhere in the
> chain,

FWIW, not one of the corrupted-data problems I've investigated has ever
looked like a single-bit error.  So the theoretical basis for using a
CRC here seems pretty weak.  I doubt we'd even consider automatic repair
attempts anyway.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Alvaro HerreraDate: 2008-10-01 15:57:31
Subject: Re: Block-level CRC checks
Previous:From: Jonah H. HarrisDate: 2008-10-01 15:54:17
Subject: Re: Block-level CRC checks

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group