Re: Block-level CRC checks

Поиск
Список
Период
Сортировка
От pgsql@mohawksoft.com
Тема Re: Block-level CRC checks
Дата
Msg-id 57064.71.232.149.185.1222897893.squirrel@mail.mohawksoft.com
обсуждение исходный текст
Ответ на Re: Block-level CRC checks  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Block-level CRC checks  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Block-level CRC checks  (Gregory Stark <stark@enterprisedb.com>)
Список pgsql-hackers
> Aidan Van Dyk <aidan@highrise.ca> writes:
>> One possibility would be to "double-buffer" the write... i.e. as you
>> calculate your CRC, you're doing it on a local copy of the block, which
>> you hand to the OS to write...  If you're touching the whole block of
>> memory to CRC it, it isn't *ridiculously* more expensive to copy the
>> memory somewhere else as you do it...
>
> That actually seems like a really good idea.  We don't have to increase
> the buffer locking requirements, or make much of any change at all in
> the existing logic.  +1, especially if this is intended to be an
> optional feature (which I agree with).
>
I don't think it make sense at all!!!

If you are going to double buffer, one presumes that for some non-zero
period of time, the block must be locked during which it is copied. You
wouldn't want it changing "mid-copy" would you? How is this any less of a
hit than just calculating the checksum?


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

Предыдущее
От: "David E. Wheeler"
Дата:
Сообщение: Re: [Review] Tests citext casts by David Wheeler.
Следующее
От: "Darren Weber"
Дата:
Сообщение: Fwd: Has anyone built pgbash-7.3 against postgreSQL-8.3?