Re: Beating Oracle - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: Beating Oracle
Date
Msg-id 29985.1015010073@sss.pgh.pa.us
Whole thread Raw
In response to Re: Beating Oracle  (Tom Ivar Helbekkmo <tih@kpnQwest.no>)
Responses Re: Beating Oracle
List pgsql-interfaces
Tom Ivar Helbekkmo <tih@kpnQwest.no> writes:
>> Non-broken TCP stacks are normally quite tenacious about surviving
>> transmission glitches in already-open connections.

> ...but you can turn part of that off by turning on SO_KEEPALIVE.

In an RFC-compliant stack, the outage interval required before KEEPALIVE
will kill the connection is of the order of hours.  RFC 1122 specifies
that the minimum interval before the first probe is even sent is 2 hours
(since last activity on connection), and that a single failed probe is
not sufficient reason to drop the connection.

RFC 2525 does note that excessively short keepalive timeout is a common
form of TCP-stack bug.
        regards, tom lane


pgsql-interfaces by date:

Previous
From: Tom Ivar Helbekkmo
Date:
Subject: Re: Beating Oracle
Next
From: Tom Ivar Helbekkmo
Date:
Subject: Re: Beating Oracle