Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1c33eH-0006Dy-S3 for pgsql-admin@arkaria.postgresql.org; Sat, 05 Nov 2016 16:16:53 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1c33eH-0002eH-Eh for pgsql-admin@arkaria.postgresql.org; Sat, 05 Nov 2016 16:16:53 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1c33ca-0000O5-81 for pgsql-admin@postgresql.org; Sat, 05 Nov 2016 16:15:08 +0000 Received: from mout.perfora.net ([74.208.4.197]) by makus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.84_2) (envelope-from ) id 1c33cX-0001RF-U9 for pgsql-admin@postgresql.org; Sat, 05 Nov 2016 16:15:07 +0000 Received: from [192.168.1.123] ([68.98.129.129]) by mrelay.perfora.net (mreueus003) with ESMTPSA (Nemesis) id 0Mbij5-1cJtY341kz-00Iz9f; Sat, 05 Nov 2016 17:15:03 +0100 Message-ID: <581E059D.4080105@sqlexec.com> Date: Sat, 05 Nov 2016 12:15:25 -0400 From: "michael@sqlexec.com" User-Agent: Postbox 5.0.5 (Windows/20161020) MIME-Version: 1.0 To: Sumeet Shukla , pgsql-admin Subject: Re: Too many Idle Connections References: <7e0ea0c1-228e-a04a-dfd5-9bccb1a5b4cf@commandprompt.com> In-Reply-To: <7e0ea0c1-228e-a04a-dfd5-9bccb1a5b4cf@commandprompt.com> Content-Type: multipart/alternative; boundary="------------050606080909050705060406" X-Provags-ID: V03:K0:dGHFbY2qgPtAI9/YoWxg+hueoC4NewcWGIn08LO+Dd5Jm9/7OzQ kpBz27DR+VdP2tNd67DLJH5zmfAsuZy1ybtF0/AstJVXVP8AsIZeak7rLzW2L4ZV45D7qAh cX7vtRKFMsczK2htjl9psCD3wl2b3lsJsjPL1PsMkrlm5zW3Q46l4LL1iEs70h6c1K6VpRi bTavFAVNyztgVE4PbFc6Q== X-UI-Out-Filterresults: notjunk:1;V01:K0:twpIUUtlLdk=:7ms5gBV+55bYNqoxo9TfVO DiMBPW35aUU7yJKdEqdYz4lAIARE6BYCIxnF3oZHwDUxqQH2byyLJRnyAkSD/DRFQHes9ju/y HJV8M0wdlplvByGg7h2STTsoj3i8428/oAtDQdBu051O77Fk22GapcoGaGrk6q9uO9dl4vOQc K5B1pnfQ9ILiGVf4ITbUvZ2HU/2pdBFvBJNZRnfOBjYdS7uNWp7Pk47QqiAywAnTKlTCmYajX l7Mqtqz4JpoWJkgHrwffCIrcAnQjRFungZ9PR1Bt1R6Y32hBwy2Y/4unGOece+cJUjipU1/e7 NUUi2neTctEieWdEb2232WYWA0JErqsjyKtMrFU7KExWhZT9WIDYV2CvJMBQZhHlatXXFp6o0 KdWo5zpwzjVyH4Xrimwo1KxWyC5h88hWBlTnDBMSB/Wc/XP5N1dagA7kQ41nj2G4myIN5k0SA ksAqvKJ7NqHDC3DDMrrg41z0xcO8lNPLtUu7bzXoxC2lMm3s9dOwqssi4GNdr/AcTPRNcCVkQ m9YJp9KZ/6wwdntfwIFRIFM0LXR7tzmDyuPtnLgwDCgWEUdlWIIkpwtnCXqGDy7h4VpiKZS3d PkQ870CNPbw3ajWAgObi7XlYW47VseCWvQXxMXq1A7cWWdaPgVpmSEznMqg3RSDmkvqD1qdpg XOxWkHJk/ZdyGlCqTe6eM9Yx/zEvUZiXutTT8bvLa8UniVFksBhTr24XcQx3xBsSsbxLM1XUS nyXERpbL9D+ORjwT X-Pg-Spam-Score: -1.4 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a multi-part message in MIME format. --------------050606080909050705060406 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit 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 > 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 > > --------------050606080909050705060406 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit 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
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



--------------050606080909050705060406--