Re: Keepalive - Mailing list pgsql-admin

From Tom Lane
Subject Re: Keepalive
Date
Msg-id 2300378.1718378913@sss.pgh.pa.us
Whole thread Raw
In response to Keepalive  (Rui DeSousa <rui.desousa@icloud.com>)
Responses Re: Keepalive
List pgsql-admin
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



pgsql-admin by date:

Previous
From: Rui DeSousa
Date:
Subject: Keepalive
Next
From: Chris Hoover
Date:
Subject: Outage caused by query in IPC:MessageQueueReceive wait????