Jim Vanns <james(dot)vanns(at)framestore(dot)com> 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
In response to
pgsql-performance by date
|Next:||From: Jim Vanns||Date: 2012-07-23 15:49:25|
|Subject: Re: Odd blocking (or massively latent) issue - even with
|Previous:||From: Tom Lane||Date: 2012-07-23 15:07:45|
|Subject: Re: Shards + hash = forever running queries|