Re: Too many Idle Connections

["michael@xxxxxxxxxxx" <michael@xxxxxxxxxxx>]

JD is correct.  Tune PGPOOL Parameters.  Probably, connection_life_time is the one you should tune.  Default is that cached connections are never expired (0).  Set it to a non zero value like 600 (10 minutes) and I am assuming that connection_cache is turned on (default)

Regards,
Michael Vitale

Joshua D. Drake

Tuesday, November 1, 2016 12:46 PM

On 11/01/2016 09:44 AM, Sumeet Shukla wrote:

Hi,

I'm using pgPool and I see that there are too many idle connections
(almost 95%).

Out of 9000 connections 8500 are idle at any point in time.

Any idea how can I go about it or what should be my approach to minimize
such idle connections? What parameters do I need to look into?

Your pool is too large. This is a pgpool question.

Sincerely,

JD

Thanks & Regards,
Sumeet Shukla
Ph. No. 860 000 6512