| From: | "michael(at)sqlexec(dot)com" <michael(at)sqlexec(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-05 16:15:25 |
| Message-ID: | 581E059D.4080105@sqlexec.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)commandprompt(dot)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
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ghiureai | 2016-11-08 18:31:13 | PG 9..5 index performance Q's |
| Previous Message | xu jian | 2016-11-03 20:06:46 | query performance question |