Re: Detecting corrupted pages earlier

Поиск
Список
Период
Сортировка
От Curt Sampson
Тема Re: Detecting corrupted pages earlier
Дата
Msg-id Pine.NEB.4.51.0302181428550.386@angelic-vtfw.cvpn.cynic.net
обсуждение исходный текст
Ответ на Re: Detecting corrupted pages earlier  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Detecting corrupted pages earlier  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Mon, 17 Feb 2003, Tom Lane wrote:

> Curt Sampson <cjs@cynic.net> writes:
>
> > If it's any kind of a serious problem, maybe it would be worth keeping
> > a CRC of the header at the end of the page somewhere.
>
> See past discussions about keeping CRCs of page contents.  Ultimately
> I think it's a significant expenditure of CPU for very marginal returns
> --- the layers underneath us are supposed to keep their own CRCs or
> other cross-checks, and a very substantial chunk of the problem seems
> to be bad RAM, against which occasional software CRC checks aren't
> especially useful.

Well, I wasn't proposing the whole page, just the header. That would be
significantly cheaper (in fact, there's no real need even for a CRC;
probably just xoring all of the words in the header into one word would
be fine) and would tell you if the page was torn during the write, which
was what I was imagining the problem might be.

But bad memory, well, not much you can do about that beyond saying, "buy
ECC, dude."

cjs
-- 
Curt Sampson  <cjs@cynic.net>   +81 90 7737 2974   http://www.netbsd.org   Don't you know, in this new Dark Age, we're
alllight.  --XTC
 


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

Предыдущее
От: Curt Sampson
Дата:
Сообщение: Re: WAL replay logic (was Re: [PERFORM] Mount options for
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Detecting corrupted pages earlier