| 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: | Whole Thread | Raw Message | 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 |