Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Sun, 31 May 2009 17:14:59 -0400
- Message-id: <15301.1243804499@sss.pgh.pa.us> <text/plain>
Brian Cox <brian(dot)cox(at)ca(dot)com> 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
- References:
- Re: autovacuum hung?
- From: Brian Cox
- Re: autovacuum hung?
- Prev by Date: Re: autovacuum hung?
- Previous by thread: Re: autovacuum hung?
- Next by thread: degenerate performance on one server of 3
- Indexes: