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