On Tue, Aug 26, 2008 at 1:33 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > Alvaro Herrera <[EMAIL PROTECTED]> 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
