Tommy Gildseth <tommy(dot)gildseth(at)usit(dot)uio(dot)no> writes:
> Richard Huxton wrote:
>> Looks like part of your query results being sent. Is it hung in that one
>> system-call?
> Yes, I left it there for about ~1 hour, and that was all that ever came.
Seems like you have got a network issue. What does netstat show for the
status of that connection?
I don't think that a query cancel will blow PG off the send; you'd
probably have to resort to kill -9 on that process (with a consequent
restart of other sessions). It's odd that the kernel hasn't given up
on the connection yet ...
regards, tom lane