Re: zero_damaged_pages doesn't work - Mailing list pgsql-general

From David Boreham
Subject Re: zero_damaged_pages doesn't work
Date
Msg-id 4CA12530.1040905@boreham.org
Whole thread Raw
In response to Re: zero_damaged_pages doesn't work  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: zero_damaged_pages doesn't work  (Bruce Momjian <bruce@momjian.us>)
List pgsql-general
  On 9/27/2010 4:53 PM, Tom Lane wrote:
> The reason it tells you that data will be destroyed is that that could
> very well happen.

Re-parsing this, I think there was a mis-communication :

I'm not at all suggesting that the doc should _not_ say that data will
be corrupted.
I'm suggesting that in addition to what it currently says, it also
should say that the on-disk data won't be
changed by the page zeroing mode.

In my searching I found countless people over the past few years who had
been similarly confused into believing that it would write back the
zeroed page
to disk.





pgsql-general by date:

Previous
From: David Boreham
Date:
Subject: Re: zero_damaged_pages doesn't work
Next
From: Michael Glaesemann
Date:
Subject: Re: Deleting orphaned records (not exists is very slow)