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.