Re: idle connection timeout ... - Mailing list pgsql-hackers

From Tom Lane
Subject Re: idle connection timeout ...
Date
Msg-id 2935.1035560807@sss.pgh.pa.us
Whole thread Raw
In response to Re: idle connection timeout ...  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: idle connection timeout ...  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: idle connection timeout ...  ("Marc G. Fournier" <scrappy@hub.org>)
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Basically, total connections is to be set larger than you think you will
> ever need, while you expect per-db to be hit, and if something keeps
> trying to connect and failing, we may get very bad connection
> performance for other backends.

Hmm, I see your point.  A per-db limit *could* be useful even if it's
set high enough that you don't expect it to be hit ... but most likely
people would try to use it in a way that it wouldn't be very efficient
compared to a client-side solution.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: idle connection timeout ...
Next
From: Bruce Momjian
Date:
Subject: Re: idle connection timeout ...