> On Jun 14, 2024, at 1:47 PM, Laurenz Albe <laurenz.albe@xxxxxxxxxxx> wrote: > > On Fri, 2024-06-14 at 11:22 -0400, Rui DeSousa wrote: >> I have a very long running query that is not being terminated after a keep alive timeout event. >> The situation is that the client drops from the network, the servers’ tcp/ip stack drops the >> connection, and the Postgres query continues to run 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 my experience. My preferred platform to run Postgres on is FreeBSD >> and in cases like this the Postgres session is also terminated once the tcp/ip connection is >> dropped by the kernel. > > That would surprise me. > > There is the parameter "client_connection_check_interval" exactly for that. > > Yours, > Laurenz Albe I retested the spinner() function on Linux with the client_connection_check_interval set and it now terminates the spinner() function. Thanks! Rui.
