Search Postgresql Archives

Re: tcp keepalives not sent during long query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Yes exactly, Geoff Winkless pointed that out too.
I thought I'd found a cause for the breaking connections, but I hadn't.
Thanks a lot for your help!


On Thu, Dec 15, 2022 at 3:48 PM Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
Willy-Bas Loos <willybas@xxxxxxxxx> writes:
> 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)

That's the behavior I'd expect on a local (Unix-socket) connection
... you sure you're doing this from one of the problematic clients?

                        regards, tom lane


--
Willy-Bas Loos

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux