Re: Block-level CRC checks

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: Block-level CRC checks
Дата
Msg-id 48E4D18F.90808@enterprisedb.com
обсуждение исходный текст
Ответ на Re: Block-level CRC checks  (Brian Hurt <bhurt@janestcapital.com>)
Ответы Re: Block-level CRC checks  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Brian Hurt wrote:
> Jonah H. Harris wrote:
>> On Thu, Oct 2, 2008 at 9:07 AM, Brian Hurt <bhurt@janestcapital.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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Jonah H. Harris"
Дата:
Сообщение: Re: Block-level CRC checks
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Interval output bug in HAVE_INT64_TIMESTAMP