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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
