Keepalive

Hi All,

I have a very long running query that is not being terminated after a keep alive timeout event.  The situation is that
theclient drops from the network, the servers’ tcp/ip stack drops the connection, and the Postgres query continues to
runwithout 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 my
experience. 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. 

Does anyone know if there is a difference on how Linux handles interrupted vs FreeBSD?  I’ve actually used tcpdrop on
FreeBSDto terminate stubborn sessions that were not responding to pg_terminate_backend(). 

Is this really expected behavior on Linux?

-Rui.