Re: 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.