Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 685119FB518 for ; Fri, 21 Sep 2007 17:55:41 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 26216-04 for ; Fri, 21 Sep 2007 17:55:39 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from globalrelay.com (mail1.globalrelay.com [204.92.49.200]) by postgresql.org (Postfix) with ESMTP id 4373C9FA555 for ; Fri, 21 Sep 2007 17:55:39 -0300 (ADT) X-Virus-Scanned: Scanned by GRC-AntiVirus Gateway Received: from [63.231.179.95] (HELO davedell) by globalrelay.com (CommuniGate Pro SMTP 4.2.3) with ESMTP id 158240760; Fri, 21 Sep 2007 20:55:37 +0000 From: "Dave Dutcher" To: Cc: References: <322942.8256.qm@web30004.mail.mud.yahoo.com> Subject: Re: Low CPU Usage Date: Fri, 21 Sep 2007 15:55:36 -0500 Message-ID: <023901c7fc91$c2a79ad0$cb00a8c0@tridecap.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 Thread-Index: Acf8hxqTgmh+/N21RIStQui6h/d/BgACgz5A X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138 In-Reply-To: <322942.8256.qm@web30004.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/389 X-Sequence-Number: 26934 >From: brauagustin-susc@yahoo.com.ar >Subject: Re: [PERFORM] Low CPU Usage > >I have no idea how to continue researching this problem. Now I'm going to do some networks tests. I would go back to the slow program and try to capture the slow queries in the log file. Once you have some queries which are running slow then you can run EXPLAIN ANALYZE to see what the bottle neck is. It seems like you've found pgAdmin is slow sending across the network, but we don't know if that has anything to do with your original problems. Just my 2 cents. Dave