Re: Keepalive

Rui DeSousa <rui.desousa@icloud.com> writes:
> I have a very long running query that is not being terminated after a keep alive timeout event.  The situation is
thatthe client drops from the network, the servers’ tcp/ip stack drops the connection, and the Postgres query continues
torun without a network connection.   

> The given system is running on Linux and I’m being told this is expected behavior; however, that is not has not been
myexperience.  My preferred platform to run Postgres on is FreeBSD and in cases like this the Postgres session is also
terminatedonce the tcp/ip connection is dropped by the kernel. 

Really?

I would expect the query to keep running until the backend tries to
perform some I/O to the client.  How quickly that happens would depend
a great deal on the details of the query, but not on which OS you're
running on.

            regards, tom lane