Tommy Gildseth <[EMAIL PROTECTED]> 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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
