Re: tcp keepalives not sent during long query

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(at)sss(dot)pgh(dot)pa(dot)us> wrote:

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