RE: AW: beta testing version - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject RE: AW: beta testing version
Date
Msg-id NEBBIOAJBMEENKACLNPCIEKCCCAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Re: AW: beta testing version  (Bruce Guenter <bruceg@em.ca>)
List pgsql-hackers
> CRCs are designed to catch N-bit errors (ie N bits in a row with their
> values flipped).  N is (IIRC) the number of bits in the CRC minus one.
> So, a 32-bit CRC can catch all 31-bit errors.  That's the only guarantee
> a CRC gives.  Everything else has a 1 in 2^32-1 chance of producing the
> same CRC as the original data.  That's pretty good odds, but not a
> guarantee.

You've got a higher chance of undetected hard drive errors, memory errors,
solar flares, etc. than a CRC of that quality failing...

Chris



pgsql-hackers by date:

Previous
From: Bruce Guenter
Date:
Subject: Re: CRCs (was: beta testing version)
Next
From: mlw
Date:
Subject: HeapTuple?