Re: tcp keepalives not sent during long query
| От | Willy-Bas Loos |
|---|---|
| Тема | Re: tcp keepalives not sent during long query |
| Дата | |
| Msg-id | CAHnozTh=o-n0cgcgP7M8iyzTKPLJfhrPFr17XwE8RTyjymnEMA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: tcp keepalives not sent during long query (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: tcp keepalives not sent during long query
Re: tcp keepalives not sent during long query Re: tcp keepalives not sent during long query Re: tcp keepalives not sent during long query |
| Список | pgsql-general |
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)
SET
wbloos=# show tcp_keepalives_idle;
tcp_keepalives_idle
---------------------
0
(1 row)
Willy-Bas Loos
В списке pgsql-general по дате отправления: