Re: Millisecond-precision connect_timeout for libpq - Mailing list pgsql-hackers

From Markus Wanner
Subject Re: Millisecond-precision connect_timeout for libpq
Date
Msg-id 51DBC7DD.5000806@bluegap.ch
Whole thread Raw
In response to Millisecond-precision connect_timeout for libpq  (ivan babrou <ibobrik@gmail.com>)
Responses Re: Millisecond-precision connect_timeout for libpq
List pgsql-hackers
On 07/09/2013 09:15 AM, ivan babrou wrote:
> Database server lost network — boom, 2 seconds delay. What's the point then?

Oh, I see. Good point. It could still improve connection time during
normal operation, though.

None the less, I now agree with you: we recommend a pooler, which may be
capable of millisecond timeouts, but arguably is vastly more complex
than the proposed patch. And it even brings its own set of gotchas (lots
of connections). I guess I don't quite buy the complexity argument, yet.

Sure, gettimeofday() is subject to clock adjustments. But so is time().
And if you're setting timeouts that low, you probably know what you're
doing (or at least care about latency a lot). Or is gettimeofday() still
considerably slower on certain architectures or in certain scenarios?
Where's the complexity?

Regards

Markus Wanner



pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: [PATCH] Add an ldapoption to disable chasing LDAP referrals
Next
From: Andres Freund
Date:
Subject: Re: XLogInsert scaling, revisited