Re: [HACKERS] Checksums by default?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] Checksums by default?
Дата
Msg-id 19271.1485226058@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] Checksums by default?  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-hackers
Stephen Frost <sfrost@snowman.net> writes:
> * Tom Lane (tgl@sss.pgh.pa.us) wrote:
>> But we don't maintain the checksum of a page while it sits in shared
>> buffers.  Trying to do so would break, eg, concurrent hint-bit updates.

> Hence why I said 'clean' pages..

When we write out a page, we copy it into private memory and compute the
checksum there, right?  We don't copy the checksum back into the page's
shared-buffer image, and if we did, that would defeat the point because we
would've had to maintain exclusive lock on the buffer or else the checksum
might be out of date.  So I don't see how this works without throwing away
a lot of carefully-designed behavior.
        regards, tom lane



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

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: [HACKERS] Online enabling of page level checksums
Следующее
От: Andres Freund
Дата:
Сообщение: Re: [HACKERS] Checksums by default?