Re: [PERFORM] Process 11812 still waiting for ExclusiveLock on extension of relation

2012-07-18 Thread David Kerr
On Jul 18, 2012, at 5:08 AM, Sergey Konoplev wrote: > Hi, > > On Tue, Jul 17, 2012 at 7:57 PM, David Kerr wrote: >> I suspect that this is related to a sustained heavy load that would stop >> autovacuum from >> getting at this table... Does that sound plausible? > > Well, not sure. Let us loo

Re: [PERFORM] Process 11812 still waiting for ExclusiveLock on extension of relation

2012-07-18 Thread Sergey Konoplev
Hi, On Tue, Jul 17, 2012 at 7:57 PM, David Kerr wrote: > I suspect that this is related to a sustained heavy load that would stop > autovacuum from > getting at this table... Does that sound plausible? Well, not sure. Let us look at the table's statistics first. \x select * from pg_stat_user_t