| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Sumeet Shukla <sumeet(dot)k(dot)shukla(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Too many Idle Connections |
| Date: | 2016-11-01 16:46:39 |
| Message-ID: | 7e0ea0c1-228e-a04a-dfd5-9bccb1a5b4cf@commandprompt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Eloy Coto Pereiro | 2016-11-01 17:25:56 | Issues with WAL Timelines on follower |
| Previous Message | Sumeet Shukla | 2016-11-01 16:44:32 | Too many Idle Connections |