Re: "Hanging Connection" blocks access to table (JBossMQ)

Markus Schaber <schabi@logix-tt.com> writes:
> Is there any possibility that we make a backend realize this SIGIO (or
> whatever it gets) when the connection is closed?

I don't think it'd be a net win to add cycles to every query to check
the connection every so often.

> The same is for very long running C-Code functions (like PostGIS
> geomUnion() on geometries with millions of vertices), those also tend to
> block the backend for long times, without any possibility to kill it
> except SIGKILL.

That's the fault of the C code ... it should be doing
CHECK_FOR_INTERRUPTS periodically in any long-running loops.

            regards, tom lane