pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedToo many Idle Connections
3+ messages / 3 participants
[nested] [flat]
* Too many Idle Connections
@ 2016-11-01 16:44 Sumeet Shukla <sumeet.k.shukla@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Sumeet Shukla @ 2016-11-01 16:44 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Too many Idle Connections
@ 2016-11-01 16:46 Joshua D. Drake <jd@commandprompt.com>
parent: Sumeet Shukla <sumeet.k.shukla@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Joshua D. Drake @ 2016-11-01 16:46 UTC (permalink / raw)
To: Sumeet Shukla <sumeet.k.shukla@gmail.com>; pgsql-admin
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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Too many Idle Connections
@ 2016-11-05 16:15 michael@sqlexec.com <michael@sqlexec.com>
parent: Joshua D. Drake <jd@commandprompt.com>
0 siblings, 0 replies; 3+ messages in thread
From: michael@sqlexec.com @ 2016-11-05 16:15 UTC (permalink / raw)
To: Sumeet Shukla <sumeet.k.shukla@gmail.com>; pgsql-admin
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 <mailto:jd@commandprompt.com>
> 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
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2016-11-05 16:15 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-11-01 16:44 Too many Idle Connections Sumeet Shukla <sumeet.k.shukla@gmail.com>
2016-11-01 16:46 ` Joshua D. Drake <jd@commandprompt.com>
2016-11-05 16:15 ` michael@sqlexec.com <michael@sqlexec.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox