"Randall F. Kern" <randy@spoke.net> writes:
> I see this pretty often on 7.1b4, running on redhat linux 6.2 (or 7.0;
> same problem on both). My lockups are always either INSERT or UPDATE,
> and all the other backends are shown as "idle in transaction".
Oh? 7.1 doesn't have the problem I was thinking of, so you may have a
different issue. Could you attach to the stuck backends with gdb and
get a backtrace from each one, so we can see approximately what they're
doing? (It'd help if you've compiled with debug symbols.)
regards, tom lane