On 2013-12-02 19:30:15 +0000, valgog@gmail.com wrote:
> If a TCP connection of the SSL client (psql in our case) is gone, during
> execution of a query, that is preparing a big dataset, the process on the
> server side (the backend process) becomes unkillable, and as soon as the OS
> cleans the TCP connection away, the process starts to consume up to 60% of
> system time for it's processor and is still unkillable.
> If needed I could try to do some more experiments and collect dbg and strace
> information about that hanging processes.
Yes, that would be good. Possibly also a profile showing where time is
spent.
Greetings,
Andres Freund
--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services