Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id EFD032E0097 for ; Mon, 21 Apr 2008 06:50:52 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 55555-09 for ; Mon, 21 Apr 2008 06:50:35 -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 7F5282E002C for ; Mon, 21 Apr 2008 06:50:39 -0300 (ADT) Received: from [127.0.0.1] (localhost [127.0.0.1]) by cptwks26.careerjunction.local (Postfix) with ESMTP id D6813B7A53 for ; Mon, 21 Apr 2008 11:50:31 +0200 (SAST) Message-ID: <480C6367.3000508@careerjunction.co.za> Date: Mon, 21 Apr 2008 11:50:31 +0200 From: Adrian Moisey User-Agent: Thunderbird 2.0.0.12 (X11/20080227) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: connections slowing everything down? 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/297 X-Sequence-Number: 29790 Hi # ps -ef | grep idle | wc -l 87 # ps -ef | grep SELECT | wc -l 5 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? -- 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