Re: tcp keepalives not sent during long query

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Willy-Bas Loos <willybas(at)gmail(dot)com>
Cc: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: tcp keepalives not sent during long query
Date: 2022-12-14 17:38:24
Message-ID: 2707299.1671039504@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Willy-Bas Loos <willybas(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michel Pelletier 2022-12-14 18:01:45 Dumping security labels for extension owned tables?
Previous Message Willy-Bas Loos 2022-12-14 17:00:18 Re: tcp keepalives not sent during long query