Skip site navigation (1) Skip section navigation (2)

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

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 (view raw or flat)
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


In response to

pgsql-performance by date

Next:From: Jeff JanesDate: 2012-07-23 15:02:51
Subject: Re: Checkpointer split has broken things dramatically (was Re: DELETE vs TRUNCATE explanation)
Previous:From: Jim VannsDate: 2012-07-23 14:46:03
Subject: Re: Odd blocking (or massively latent) issue - even with EXPLAIN

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group