Re: BUG #8647: Backend process hangs and becomes unkillable when SSL client looses connection - Mailing list pgsql-bugs

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