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

From Tom Lane
Subject Re: tcp keepalives not sent during long query
Date
Msg-id 2707299.1671039504@sss.pgh.pa.us
Whole thread Raw
In response to Re: tcp keepalives not sent during long query  (Willy-Bas Loos <willybas@gmail.com>)
Responses Re: tcp keepalives not sent during long query
List pgsql-general
Willy-Bas Loos <willybas@gmail.com> writes:
> 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.

No, we just apply the setting to the open socket and trust the OS
to do it.

Are you quite certain that you applied the configuration change to
your new installation?

It'd be worth doing

show tcp_keepalives_idle;

in one of the sessions where you are having trouble.  And maybe
check the other keepalives settings too?

            regards, tom lane



pgsql-general by date:

Previous
From: Willy-Bas Loos
Date:
Subject: Re: tcp keepalives not sent during long query
Next
From: Michel Pelletier
Date:
Subject: Dumping security labels for extension owned tables?