Re: CRCs (was: beta testing version) - Mailing list pgsql-hackers

From ncm@zembu.com (Nathan Myers)
Subject Re: CRCs (was: beta testing version)
Date
Msg-id 20001207144549.B30335@store.zembu.com
Whole thread Raw
In response to RE: CRCs (was: beta testing version)  ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>)
List pgsql-hackers
On Thu, Dec 07, 2000 at 12:22:12PM -0800, Mikheev, Vadim wrote:
> > > That's why an end marker must follow all valid records.  
> ...
> > 
> > That requires an extra out-of-sequence write. 
> 
> Yes, and also increase probability to corrupt already committed
> to log data.
> 
> > (I'd also like to see CRCs on all the table blocks as well; is there
> > a place to put them?)
> 
> Do we need it? "physical log" feature suggested by Andreas will protect
> us from non atomic data block writes.

There are myriad sources of corruption, including RAM bit rot and
software bugs.  The earlier and more reliably it's caught, the better.
The goal is to be able to say that a power outage won't invisibly
corrupt your database.

Here is are sources to a 64-bit CRC computation, under BSD license:
 http://gcc.gnu.org/ml/gcc/1999-11n/msg00592.html

Nathan Myers
ncm@zembu.com


pgsql-hackers by date:

Previous
From: Alfred Perlstein
Date:
Subject: Patches with vacuum fixes available for 7.0.x
Next
From: Alfred Perlstein
Date:
Subject: abstract: fix poor constant folding in 7.0.x, fixed in 7.1?