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

Re: Block-level CRC checks

From: Brian Hurt <bhurt(at)janestcapital(dot)com>
Cc: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Block-level CRC checks
Date: 2008-10-03 13:36:19
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
OK, I have a stupid question- torn pages are a problem, but only during 
recovery.  Recovery is (I assume) a fairly rare condition- if data 
corruption is going to happen, it's most likely to happen during normal 
operation.  So why not just turn off CRC checksumming during recovery, 
or at least treat it as a much less critical error?  During recovery, if 
the CRC checksum matches, we can assume the page is good- not only not 
corrupt, but not torn either.  If the CRC checksum doesn't match, we 
don't panic, but maybe we do more careful analysis of the page to make 
sure that only the hint bits are wrong.  Or maybe not.  It's only during 
normal operation that a CRC checksum failure would be considered critical.

Feel free to explain to me why I'm an idiot.


In response to


pgsql-hackers by date

Next:From: Dawid KuroczkoDate: 2008-10-03 14:20:15
Subject: Re: Block-level CRC checks
Previous:From: Tom LaneDate: 2008-10-03 12:37:07
Subject: Re: pgsql: Add relation fork support to pg_relation_size() function.

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