Re: Beating Oracle

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Beating Oracle
Дата
Msg-id 29985.1015010073@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Beating Oracle  (Tom Ivar Helbekkmo <tih@kpnQwest.no>)
Ответы Re: Beating Oracle  (Tom Ivar Helbekkmo <tih@kpnQwest.no>)
Список 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 по дате отправления:

Предыдущее
От: Tom Ivar Helbekkmo
Дата:
Сообщение: Re: Beating Oracle
Следующее
От: Tom Ivar Helbekkmo
Дата:
Сообщение: Re: Beating Oracle