Re: tcp keepalives not sent during long query

Willy-Bas Loos <willybas@gmail.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