On Tue, Aug 26, 2008 at 1:33 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Alvaro Herrera <alvherre@commandprompt.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 ?