Re: Block-level CRC checks

Brian Hurt wrote:
> Jonah H. Harris wrote:
>> On Thu, Oct 2, 2008 at 9:07 AM, Brian Hurt <bhurt(at)janestcapital(dot)com>
>> wrote:
>>> I have a stupid question wrt hint bits and CRC checksums- it seems to me
>>> that it should be possible, if you change the hint bits, to be able
>>> to very
>>> easily calculate what the change in the CRC checksum should be.
>>
>> Doesn't the problem still remain? The problem being that the buffer
>> can be changed as it's written, yes?
>>
> Another possibility is to just not checksum the hint bits...

That would work. But I'm afraid it'd make the implementation a lot more
invasive, and also slower. The buffer manager would have to know what
kind of a page it's dealing with, heap or index or FSM or what, to know
where the hint bits are. Then it would have to follow the line pointers
to locate the hint bits, and mask them out for the CRC calculation.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com