Re: Detecting corrupted pages earlier

Kevin Brown <kevin@sysexperts.com>

From: Kevin Brown <kevin@sysexperts.com>
To: pgsql-hackers@postgresql.org
Date: 2003-03-29T11:55:20Z
Lists: pgsql-hackers
Tom Lane wrote:
> 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.

This statement should *definitely* go into the documentation for the
option, then...


-- 
Kevin Brown					      kevin@sysexperts.com