Re: can't stop autovacuum by HUP'ing the server

On Tue, Aug 26, 2008 at 1:33 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> > Dave Cramer wrote:
> >> Well, I'm willing to help debug this, however this is a busy production
> >> database and I need to be able to turn it off for a few hours a day.
> Would
> >> changing autovacuum_freeze_max_age be a solution ?
>
> > Yes.
>
> Could we first see a cycle of autovac log output with
> log_autovacuum_min_duration = 0?
> Otherwise we're not going to get closer to understanding why it's
> not cleaning up template0 for you.
>

I actually set that last time I restarted. There's nothing particularly
interesting there. Is there another log GUC that needs to be tweaked to get
more output ?

Dave