Re: locked up backends

"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