Re: CRCs - Mailing list pgsql-hackers

From ncm@zembu.com (Nathan Myers)
Subject Re: CRCs
Date
Msg-id 20010112164310.Y571@store.zembu.com
Whole thread Raw
In response to Re: CRCs  (Alfred Perlstein <bright@wintelcom.net>)
List pgsql-hackers
On Fri, Jan 12, 2001 at 04:10:36PM -0800, Alfred Perlstein wrote:
> Nathan Myers <ncm@zembu.com> [010112 15:49] wrote:
> >
> > Obviously it's better to configure the disk so that it doesn't
> > lie about what's been written.
> 
> I thought WAL+fsync wasn't supposed to allow this to happen?

It's an OS and hardware configuration matter; you only get correct
WAL+fsync semantics if the underlying system is configured right.  
IDE disks are almost always configured wrong, to spoof benchmarks; 
SCSI disks sometimes are.

If they're configured wrong, then (now that we have a CRC in the 
log entry) in the event of a power outage the database might come 
back with recently-acknowledged transaction results discarded.
That's a lot better than a corrupt database, but it's not 
industrial-grade semantics.  (Use a UPS.)

Nathan Myers
ncm@zembu.com


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: CRCs
Next
From: The Hermit Hacker
Date:
Subject: Re: CVS updates on committers list...