Re: Detecting corrupted pages earlier - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Detecting corrupted pages earlier
Date
Msg-id 25035.1048887218@sss.pgh.pa.us
Whole thread Raw
In response to Re: Detecting corrupted pages earlier  (Kris Jurka <books@ejurka.com>)
Responses Re: Detecting corrupted pages earlier  (Kevin Brown <kevin@sysexperts.com>)
List pgsql-hackers
Kris Jurka <books@ejurka.com> writes:
> Is zeroing the pages the only / best option?

It's the only way to avoid a core dump when the system tries to process
the page.  And no, I don't want to propagate the notion that "this page
is broken" beyond the buffer manager, so testing elsewhere isn't an
acceptable answer.

Basically, one should only turn this variable on after giving up on the
possibility of getting any data out of the broken page itself.  It would
be folly to run with it turned on as a normal setting.
        regards, tom lane



pgsql-hackers by date:

Previous
From: mlw
Date:
Subject: Re: PostgreSQL and SOAP, version 7.4/8.0
Next
From: Steve Wampler
Date:
Subject: Re: PostgreSQL and SOAP, version 7.4/8.0