Too many Idle Connections
Too many Idle Connections
От:
Sumeet Shukla <sumeet.k.shukla@gmail.com>
Дата:
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?
Thanks & Regards,
Sumeet Shukla
Ph. No. 860 000 6512
Re: Too many Idle Connections
От:
"Joshua D. Drake" <jd@commandprompt.com>
Дата:
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.
Re: Too many Idle Connections
От:
"michael@sqlexec.com" <michael@sqlexec.com>
Дата:
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
Regards,
Michael Vitale
Tuesday, November 1, 2016 12:46 PMOn 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