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. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
