From: michael@sqlexec.com <michael@sqlexec.com>
To: Sumeet Shukla <sumeet.k.shukla@gmail.com>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Too many Idle Connections
Date: Sat, 05 Nov 2016 12:15:25 -0400
Message-ID: <581E059D.4080105@sqlexec.com> (raw)
In-Reply-To: <7e0ea0c1-228e-a04a-dfd5-9bccb1a5b4cf@commandprompt.com>
References: <CABUL134MKpOV0=4BT1nMS9cP_qUj6UcC+OpRfuT7KDU_JSCKtw@mail.gmail.com>
<7e0ea0c1-228e-a04a-dfd5-9bccb1a5b4cf@commandprompt.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: michael@sqlexec.com, sumeet.k.shukla@gmail.com
Subject: Re: Too many Idle Connections
In-Reply-To: <581E059D.4080105@sqlexec.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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