Re: tcp keepalives not sent during long query - Mailing list pgsql-general

From Willy-Bas Loos
Subject Re: tcp keepalives not sent during long query
Date
Msg-id CAHnozTitEe9Zm6xizq6KyWCUYbtH2oUZDeFVbpXmK=Lm_aY6Zg@mail.gmail.com
Whole thread Raw
In response to Re: tcp keepalives not sent during long query  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: tcp keepalives not sent during long query  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Thanks for your answer. I was afraid someone would say that...
I was hoping that the keepalives would be more of a matter of cooperation between postgres and the OS.


On Wed, Dec 14, 2022 at 10:52 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
On Wed, 2022-12-14 at 08:55 +0100, Willy-Bas Loos wrote:
> Some users of our database have a NAT firewall and keep a postgres client (e.g. pgAdmin )
> open for hours. To prevent the connection from being killed by the firewall due to inactivity,
> we configured tcp_keepalives_idle = 120 so that the server sends keepalives and keeps the
> connection active. (this is on debian)
>
> We've recently upgraded from postgres 9.3 to 13 and from debian 6 to 11.
> I'm getting the complaint that since the upgrade, the connection breaks. But only when they run a long query.
>
> Has anything changed in postgres that might cause this? e.g. that keepalives are only sent when the session is idle?

It is the operating system kernel that sends keepalives, so that should be independent of
what the PostgreSQL backend is doing.

Yours,
Laurenz Albe


--
Willy-Bas Loos

pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: tcp keepalives not sent during long query
Next
From: Tom Lane
Date:
Subject: Re: tcp keepalives not sent during long query