Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 9B5859F9275 for ; Tue, 30 Oct 2007 01:00:40 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 07042-03-7 for ; Tue, 30 Oct 2007 01:00:12 -0300 (ADT) X-Greylist: delayed 00:06:40.477824 by SQLgrey-1.7.5 Received: from web57110.mail.re3.yahoo.com (web57110.mail.re3.yahoo.com [216.252.111.123]) by postgresql.org (Postfix) with SMTP id 0A7ED9F9E6E for ; Tue, 30 Oct 2007 00:56:00 -0300 (ADT) Received: (qmail 3447 invoked by uid 60001); 30 Oct 2007 03:49:19 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=VQDxK48Kp19YQjHjMj3OAL3KICQAjsVSnBN+m74PPRm+I6vu9OAx5eQY1/yl0IKIAWF04NY4hRyeqyaPgx3BLxmOxLhZt2V/wN8PmZleqvZ03dLsLv3w0k/wHzTdTZwNnnVyHapVRntooP7+vWtVvEXoZ5N524d5e4/z9G3HJho=; X-YMail-OSG: O9ldNfMVM1lagMh_dbFKdEVFeTPBUzPy9hVLDhChsCWorEIToVOBxVu7XxvNRahFc2l6TSqldjRtrcIn9UHBauyMcs5QuLJzTsWbJv_yX2n7hY8lCWLKMvtFQfxBiZHbvj.oC2noO.m3EhlAup5lfkuE Received: from [64.237.4.140] by web57110.mail.re3.yahoo.com via HTTP; Mon, 29 Oct 2007 20:49:19 PDT Date: Mon, 29 Oct 2007 20:49:19 -0700 (PDT) From: Abu Mushayeed Subject: High system CPU usage during query run To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1075934789-1193716159=:3211" Content-Transfer-Encoding: 8bit Message-ID: <219953.3211.qm@web57110.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.661 tagged_above=0 required=5 tests=AWL=0.845, BAYES_40=-0.185, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200710/300 X-Sequence-Number: 27214 --0-1075934789-1193716159=:3211 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hello, I have a problem with my database that I cannot fugure out. We have queries running on the server and we observe that the sytem CPU% usage goes to 97 - 98% and the quries take tremendous amount of time to finish. On other days the queries would run quick and the system CPU usage percentage is low. We have done disk scans and did not find issue as per the sys admin. What from the database perspective I should investigate to resolve the issue? Our server has dual core Intel Xeon processors 2.66 GHZ, 16GB RAM and RAID10 1.5 TB. Please I need advise on this problem. Thanks Abu __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --0-1075934789-1193716159=:3211 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
Hello,
 
I have a problem with my database that I cannot fugure out. We have queries running on the server and we observe that the sytem CPU% usage goes to 97 - 98% and the quries take tremendous amount of time to finish. On other days the queries would run quick and the system CPU usage percentage is low.
 
We have done disk scans and did not find issue as per the sys admin. What from the database perspective I should investigate to resolve the issue?
 
Our server has dual core Intel Xeon processors 2.66 GHZ, 16GB RAM and RAID10 1.5 TB.
 
Please I need advise on this problem.
 
Thanks
Abu

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com --0-1075934789-1193716159=:3211--