Re: autovacuum hung?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Brian Cox <brian(dot)cox(at)ca(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: autovacuum hung?
Date: 2009-05-31 19:34:37
Message-ID: 13768.1243798477@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Brian Cox <brian(dot)cox(at)ca(dot)com> writes:
> Dp you think it would be better to manually
> vacuum these tables? If so, would it be best to disable autovacuum of
> them? And while I'm at it, if you disable autovacuum of the master table
> will that disable it for the actual partitions?

No, no, and no. What would be best is to find out what actually
happened. The evidence is gone now, but if you see it again please
take a closer look.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Brian Cox 2009-05-31 20:44:40 Re: autovacuum hung?
Previous Message Brian Cox 2009-05-31 19:08:25 Re: autovacuum hung?