Re: [HACKERS] Checksums by default?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] Checksums by default?
Дата
Msg-id 18368.1485224662@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] Checksums by default?  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Ответы Re: [HACKERS] Checksums by default?  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Re: [HACKERS] Checksums by default?  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-hackers
Jim Nasby <Jim.Nasby@bluetreble.com> writes:
> On 1/23/17 7:47 PM, Stephen Frost wrote:
>> It might be interesting to consider checking them in 'clean' pages in
>> shared_buffers in a background process, as that, presumably, *would*
>> detect shared buffers corruption.

> Hmm... that would be interesting. Assuming the necessary functions are 
> exposed it presumably wouldn't be difficult to do that in an extension, 
> as a bgworker.

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.
        regards, tom lane



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

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: [HACKERS] Checksums by default?
Следующее
От: Jim Nasby
Дата:
Сообщение: Re: [HACKERS] Checksums by default?