Re: TCP keepalive support for libpq - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: TCP keepalive support for libpq
Date
Msg-id 3f0b79eb1002111852t106baee9x8913ba52c6c65f9c@mail.gmail.com
Whole thread Raw
In response to Re: TCP keepalive support for libpq  (Peter Geoghegan <peter.geoghegan86@gmail.com>)
Responses Re: TCP keepalive support for libpq
List pgsql-hackers
On Fri, Feb 12, 2010 at 1:33 AM, Peter Geoghegan
<peter.geoghegan86@gmail.com> wrote:
> Why hasn't libpq had keepalives for years?

I guess that it's because keepalive doesn't work as expected
in some cases. For example, if the network outage happens
before a client sends some packets, keepalive doesn't work,
then it would have to wait for a long time until it detects
the outage. This is the specification of linux kernel. So
a client should not have excessive expectations of keepalive,
and should have another timeout like QueryTimeout of JDBC.

Regards,

-- 
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center


pgsql-hackers by date:

Previous
From: Euler Taveira de Oliveira
Date:
Subject: Re: Hostnames in pg_hba.conf
Next
From: Robert Haas
Date:
Subject: Re: Writeable CTEs and empty relations