The following bug has been logged on the website:
Bug reference: 8647
Logged by: Valentine Gogichashvili
Email address: valgog@gmail.com
PostgreSQL version: 9.2.4
Operating system: Linux 3.2.0-48-generic Ubuntu x86_64
Description:
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.
We can reproduce the problem on all the versions from 9.0 up to 9.2. On the
9.3 the problem is unreproducible though.
If needed I could try to do some more experiments and collect dbg and strace
information about that hanging processes.