Re: Odd blocking (or massively latent) issue - even with EXPLAIN

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Jim Vanns <james(dot)vanns(at)framestore(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Odd blocking (or massively latent) issue - even with EXPLAIN
Date: 2012-07-23 13:53:25
Message-ID: 500D5755.30803@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Craig Ringer 2012-07-23 13:58:47 Re: Checkpointer split has broken things dramatically (was Re: DELETE vs TRUNCATE explanation)
Previous Message Andrew Dunstan 2012-07-23 13:47:16 Re: Checkpointer split has broken things dramatically (was Re: DELETE vs TRUNCATE explanation)