Re: SO_KEEPALIVE - Mailing list pgsql-hackers

From Oliver Jowett
Subject Re: SO_KEEPALIVE
Date
Msg-id 428B4551.7080806@opencloud.com
Whole thread Raw
In response to Re: SO_KEEPALIVE  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: SO_KEEPALIVE
Re: SO_KEEPALIVE
List pgsql-hackers
Tom Lane wrote:

> On the other hand, it seems to me a client-side SO_KEEPALIVE would only
> be interesting for completely passive clients (perhaps one that sits
> waiting for NOTIFY messages?)  A normal client will try to issue some
> kind of database command once in awhile, and as soon as that happens,
> there is a reasonably short timeout before connection failure is reported.

If you're unlucky, the server could go down while you're blocked waiting
for a query response..

-O


pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Ingres dump files to PostgreSQL
Next
From: Gaetano Mendola
Date:
Subject: Re: SO_KEEPALIVE