Postgres Pro
Downloads
Home   >   mailing lists

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 CAHnozTh=o-n0cgcgP7M8iyzTKPLJfhrPFr17XwE8RTyjymnEMA@mail.gmail.com
Whole thread Raw
In response to Re: tcp keepalives not sent during long query  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: tcp keepalives not sent during long query  (Willy-Bas Loos <willybas@gmail.com>)
Re: tcp keepalives not sent during long query  (Laurenz Albe <laurenz.albe@cybertec.at>)
Re: tcp keepalives not sent during long query  (Geoff Winkless <pgsqladmin@geoff.dj>)
Re: tcp keepalives not sent during long query  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view


On Wed, Dec 14, 2022 at 6:38 PM Tom Lane <tgl@sss.pgh.pa.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)

--
Willy-Bas Loos

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Test if a database has any privilege granted to public
Next
From: Willy-Bas Loos
Date:
Subject: Re: tcp keepalives not sent during long query