Re: autovacuum hung?

From: Tom Lane
Subject: Re: autovacuum hung?
Date: ,
Msg-id: 13768.1243798477@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: Re: autovacuum hung?  (Brian Cox)
List: pgsql-performance

Tree view

autovacuum hung?  (Brian Cox, )
 Re: autovacuum hung?  (Alvaro Herrera, )
 Re: autovacuum hung?  (Brian Cox, )
 Re: autovacuum hung?  (Tom Lane, )
 Re: autovacuum hung?  (Brian Cox, )
  Re: autovacuum hung?  (Tom Lane, )
 Re: autovacuum hung?  (Brian Cox, )
  Re: autovacuum hung?  (Tom Lane, )
 Re: autovacuum hung?  (Brian Cox, )
  Re: autovacuum hung?  (Tom Lane, )
  Re: autovacuum hung?  (Tom Lane, )
 Re: autovacuum hung?  (Brian Cox, )

Brian Cox <> 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


pgsql-performance by date:

From: Tom Lane
Date:
Subject: Re: autovacuum hung?
From: Craig Ringer
Date:
Subject: Re: degenerate performance on one server of 3