Re: BUG #2576: tcp_keepalive doesn't work - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #2576: tcp_keepalive doesn't work
Date
Msg-id 11047.1156167681@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #2576: tcp_keepalive doesn't work  (Fujii Masao <fujii.masao@oss.ntt.co.jp>)
List pgsql-bugs
Fujii Masao <fujii.masao@oss.ntt.co.jp> writes:
> Because 'idle in transaction' backends that don't terminate by tcp_keepalive
> keep holding the lock.

If a backend has gotten to the point of being 'idle in transaction',
then it's certainly exchanged data with the client, so TCP keepalive
should work.  I suggest you need to file a kernel bug report if it
doesn't.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Fujii Masao
Date:
Subject: Re: BUG #2576: tcp_keepalive doesn't work
Next
From: ""
Date:
Subject: BUG #2585: Please provide pkg-config support