Обсуждение: Too many Idle Connections

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


--
Command Prompt, Inc.                  http://the.postgres.company/
                         +1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.
Unless otherwise stated, opinions are my own.

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