Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 25DB22E0090 for ; Mon, 21 Apr 2008 11:15:56 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 68345-06 for ; Mon, 21 Apr 2008 11:15:52 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from cptwks26.careerjunction.local (unknown [196.212.105.173]) by developer.postgresql.org (Postfix) with ESMTP id C18782E0082 for ; Mon, 21 Apr 2008 11:15:49 -0300 (ADT) Received: from [127.0.0.1] (localhost [127.0.0.1]) by cptwks26.careerjunction.local (Postfix) with ESMTP id 3051AB7A53; Mon, 21 Apr 2008 16:15:43 +0200 (SAST) Message-ID: <480CA18E.3090309@careerjunction.co.za> Date: Mon, 21 Apr 2008 16:15:42 +0200 From: Adrian Moisey User-Agent: Thunderbird 2.0.0.12 (X11/20080227) MIME-Version: 1.0 To: Erik Jones CC: pgsql-performance@postgresql.org Subject: Re: connections slowing everything down? References: <480C6367.3000508@careerjunction.co.za> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/300 X-Sequence-Number: 29793 Hi >> # ps -ef | grep idle | wc -l >> 87 [...] >> I have 2 web servers which connect to PGPool which connects to our >> postgres db. I have noticed that idle connections seem to take up CPU >> and RAM (according to top). Could this in any way cause things to >> slow down? > > Dependant on how much memory you have in your system, yes. You can fix > the constant use of memory by idle connections by adjusting the > child_life_time setting in your pgpool.conf file. The default if 5 > minutes which a bit long. Try dropping that down to 20 or 30 seconds. We have 32GBs. If I get it to close the connections faster, will that actually help? Is there a way i can figure it out? -- Adrian Moisey Systems Administrator | CareerJunction | Your Future Starts Here. Web: www.careerjunction.co.za | Email: adrian@careerjunction.co.za Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842