Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1USvqU-0005wV-AW for pgsql-performance@arkaria.postgresql.org; Thu, 18 Apr 2013 20:54:18 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1USvqT-0002i5-N8 for pgsql-performance@arkaria.postgresql.org; Thu, 18 Apr 2013 20:54:17 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1USvqS-0002i0-Sp for pgsql-performance@postgresql.org; Thu, 18 Apr 2013 20:54:17 +0000 Received: from proofpoint1.mail.rice.edu ([128.42.201.100] helo=pp1.rice.edu) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1USvqM-0005fC-B7 for pgsql-performance@postgresql.org; Thu, 18 Apr 2013 20:54:15 +0000 Received: from pps.filterd (pp1.rice.edu [127.0.0.1]) by pp1.rice.edu (8.14.5/8.14.5) with SMTP id r3IJg0mN022314; Thu, 18 Apr 2013 15:54:09 -0500 Received: from mh1.mail.rice.edu (mh1.mail.rice.edu [128.42.201.20]) by pp1.rice.edu with ESMTP id 1brr7st8m6-1; Thu, 18 Apr 2013 15:54:09 -0500 X-Virus-Scanned: by amavis-2.7.0 at mh1.mail.rice.edu, auth channel X-SMTP-Auth: no X-SMTP-Auth: no Received: from aart.rice.edu (aart.rice.edu [168.7.56.48]) by mh1.mail.rice.edu (Postfix) with ESMTP id 0BE1E4600E7; Thu, 18 Apr 2013 15:54:09 -0500 (CDT) Received: by aart.rice.edu (Postfix, from userid 18612) id CA450100658; Thu, 18 Apr 2013 15:54:08 -0500 (CDT) Date: Thu, 18 Apr 2013 15:54:08 -0500 From: "ktm@rice.edu" To: bing1221 Cc: pgsql-performance@postgresql.org Subject: Re: High CPU usage buy low I/O wait Message-ID: <20130418205408.GI32580@aart.rice.edu> References: <1365723054732-5751860.post@n5.nabble.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1365723054732-5751860.post@n5.nabble.com> User-Agent: Mutt/1.5.20 (2009-12-10) X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org On Thu, Apr 11, 2013 at 04:30:54PM -0700, bing1221 wrote: > Our server is running postgresql 8.4.15. During day time the cpu usage always > around 80%, but it's not IO bound. The swap space is looking OK also. Also > we setup pgbadger and enable all logs to monitor the slow query but they all > finished quick. Usually it has 60 incoming connections, and we have > pgbouncer to control the pool. Any suggestions I can look into it? Thank > you. Why do you think you have a problem? It sounds like normal system usage. Regards, Ken -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance