From: | Jim Vanns <james(dot)vanns(at)framestore(dot)com> |
---|---|
To: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
Cc: | Jim Vanns <james(dot)vanns(at)framestore(dot)com>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Odd blocking (or massively latent) issue - even with EXPLAIN |
Date: | 2012-07-23 14:47:22 |
Message-ID: | 1343054842.12579.112.camel@sys367.ldn.framestore.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On Mon, 2012-07-23 at 09:53 -0400, Andrew Dunstan wrote:
> On 07/23/2012 04:41 AM, Jim Vanns wrote:
> > We're seeing SELECT statements and even EXPLAIN (no ANAYLZE)
> > statements hang indefinitely until *something* (we don't know what)
> > releases some kind of resource or no longer becomes a massive bottle
> > neck. These are the symptoms.
>
> I have seen this sort of behaviour on systems with massive catalogs
> (millions of tables and indexes). Could that be your problem?
Possibly. I'm not familiar with the catalogs. I'll look into that.
Thanks,
Jim
>
> cheers
>
> andrew
>
--
Jim Vanns
Systems Programmer
Framestore
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Janes | 2012-07-23 15:02:51 | Re: Checkpointer split has broken things dramatically (was Re: DELETE vs TRUNCATE explanation) |
Previous Message | Jim Vanns | 2012-07-23 14:46:03 | Re: Odd blocking (or massively latent) issue - even with EXPLAIN |