Re: Zeroing damaged pages

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
>> On Thu, 2006-02-23 at 11:54 -0500, Tom Lane wrote:
>>> Hmm .... it'd probably be a good idea to force zero_damaged_pages OFF in
>>> the autovac subprocess.  That parameter is only intended for interactive
>>> use --- as you say, autovac would be a rather nasty loose cannon if it
>>> fired up with this parameter ON.

> I am wondering if we should prevent autovac from running if
> zero_damaged_pages is set in postgresql.conf.

What's wrong with just turning it off locally in the autovac process?

If the admin prefers autovac not run at all while he's fooling around,
he can disable it in postgresql.conf (or perhaps even better, run in
single-user mode).  But I don't think it's appropriate to force that
decision on him.

			regards, tom lane