Re: tcp keepalives not sent during long query

On Thu, 2022-12-15 at 08:31 +0100, Willy-Bas Loos wrote:
> On Wed, Dec 14, 2022 at 6:38 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> > It'd be worth doing
> >
> > show tcp_keepalives_idle;
>
> Wow, you're right! It's in the postgresql.conf but it isn't set when I reload the server
> A restart also doesn't do it and even doing SET tcp_keepalives_idle=120; doesn't work.
> It gives me a confirmation, but then when I SHOW the value, it gives me 0.
>
> wbloos=# set tcp_keepalives_idle=120;
> SET
> wbloos=# show tcp_keepalives_idle;
>  tcp_keepalives_idle
> ---------------------
>  0
> (1 row)

One good way to debug this is

SELECT setting, source, sourcefile, sourceline
FROM pg_settings
WHERE name = 'tcp_keepalives_idle';

That will tell you from where you get the parameter value.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com