Re: autovacuum hung?

From: Tom Lane
Subject: Re: autovacuum hung?
Date: ,
Msg-id: 15301.1243804499@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:
> OK. You mentioned strace. It's got a lot of options; any in particular
> that would be useful if this happens again?

Oh, and don't forget the more-complete pg_locks state.  We'll want all
the columns of pg_locks, not just the ones you showed before.

            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