Jim Vanns <james.vanns@xxxxxxxxxxxxxx> writes: > 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. Does anything show up as blocked in the pg_locks view? Could you attach to the stuck process with gdb and get a stack trace? regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
