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

From Tom Lane
Subject Re: TCP keepalive support for libpq
Date
Msg-id 3373.1277225440@sss.pgh.pa.us
Whole thread Raw
In response to Re: TCP keepalive support for libpq  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: TCP keepalive support for libpq  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> What does bother me is the fact that we are engineering a critical
> aspect of our system reliability around vendor-specific implementation
> details of the TCP stack, and that if any version of any operating
> system that we support (or ever wish to support in the future) fails
> to have a reliable implementation of this feature AND configurable
> knobs that we can tune to suit our needs, then we're screwed.  Does
> anyone want to argue that this is NOT a house of cards?

By that argument, we need to be programming to bare metal on every disk
access.  Does anyone want to argue that depending on vendor-specific
filesystem functionality is not a house of cards?  (And unfortunately,
that's much too close to the truth ... but yet we're not going there.)

As for the original point: *of course* we are going to have to expose
the keepalive parameters.  The default timeouts are specified by RFC,
and they're of the order of hours.  That's not going to satisfy anyone
for this usage.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_upgrade issues
Next
From: "Kevin Grittner"
Date:
Subject: Re: TCP keepalive support for libpq