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