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.
In response to
pgsql-performance by date
|Next:||From: Jeff Janes||Date: 2012-07-23 15:02:51|
|Subject: Re: Checkpointer split has broken things dramatically (was
Re: DELETE vs TRUNCATE explanation)|
|Previous:||From: Jim Vanns||Date: 2012-07-23 14:46:03|
|Subject: Re: Odd blocking (or massively latent) issue - even with