Subject: Re: Too many Idle Connections
To: Sumeet Shukla <sumeet.k.shukla@gmail.com>,
 pgsql-admin <pgsql-admin@postgresql.org>
References: 
 <CABUL134MKpOV0=4BT1nMS9cP_qUj6UcC+OpRfuT7KDU_JSCKtw@mail.gmail.com>
From: "Joshua D. Drake" <jd@commandprompt.com>
Organization: Command Prompt, Inc.
Message-ID: <7e0ea0c1-228e-a04a-dfd5-9bccb1a5b4cf@commandprompt.com>
Date: Tue, 1 Nov 2016 09:46:39 -0700
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101
 Thunderbird/45.3.0
MIME-Version: 1.0
In-Reply-To: 
 <CABUL134MKpOV0=4BT1nMS9cP_qUj6UcC+OpRfuT7KDU_JSCKtw@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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