Re: Too many Idle Connections - Mailing list pgsql-admin

From Joshua D. Drake
Subject Re: Too many Idle Connections
Date
Msg-id 7e0ea0c1-228e-a04a-dfd5-9bccb1a5b4cf@commandprompt.com
Whole thread Raw
In response to Too many Idle Connections  (Sumeet Shukla <sumeet.k.shukla@gmail.com>)
Responses Re: Too many Idle Connections  ("michael@sqlexec.com" <michael@sqlexec.com>)
List 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.


pgsql-admin by date:

Previous
From: Sumeet Shukla
Date:
Subject: Too many Idle Connections
Next
From: Eloy Coto Pereiro
Date:
Subject: Issues with WAL Timelines on follower