Postgres Pro
Downloads
Home   >   mailing lists

Re: Odd blocking (or massively latent) issue - even with EXPLAIN - Mailing list pgsql-performance

From Andrew Dunstan
Subject Re: Odd blocking (or massively latent) issue - even with EXPLAIN
Date
Msg-id 500D5755.30803@dunslane.net
Whole thread Raw
In response to Odd blocking (or massively latent) issue - even with EXPLAIN  (Jim Vanns <james.vanns@framestore.com>)
Responses Re: Odd blocking (or massively latent) issue - even with EXPLAIN  (Jim Vanns <james.vanns@framestore.com>)
List pgsql-performance
Tree view 
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?


cheers

andrew

pgsql-performance by date:

Previous
From: "Martin French"
Date:
Subject: Re: Odd blocking (or massively latent) issue - even with EXPLAIN
Next
From: Jim Vanns
Date:
Subject: Re: Odd blocking (or massively latent) issue - even with EXPLAIN