Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 49F669F9697 for ; Tue, 30 Oct 2007 01:43:16 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 47382-03 for ; Tue, 30 Oct 2007 01:43:09 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from weatherbeeta.com.au (218-214-212-153.people.net.au [218.214.212.153]) by postgresql.org (Postfix) with ESMTP id 3F3869F987C for ; Tue, 30 Oct 2007 01:43:07 -0300 (ADT) Received: (qmail 16802 invoked from network); 30 Oct 2007 04:43:06 -0000 X-NetworkBox-HamSign: 0101;OUT;wbeetaau1;a8a3e3244b0130e4e33e487403e5408f; Received: from unknown (HELO mail.weatherbeeta.com.au) (10.20.0.2) by 10.20.0.254 with SMTP; 30 Oct 2007 04:43:05 -0000 Received: (qmail 17462 invoked by uid 1166); 30 Oct 2007 15:42:59 +1100 Received: from 172.20.0.155 by mail.weatherbeeta.com.au (envelope-from , uid 1165) with qmail-scanner-1.25-st-qms (clamdscan: 0.88.6/2315. perlscan: 1.25-st-qms. Clear:RC:1(172.20.0.155):. Processed in 0.230765 secs); 30 Oct 2007 04:42:59 -0000 X-Antivirus-mail.weatherbeeta.com.au-Mail-From: phillip.smith@weatherbeeta.com.au via mail.weatherbeeta.com.au X-Antivirus-mail.weatherbeeta.com.au: 1.25-st-qms (Clear:RC:1(172.20.0.155):. Processed in 0.230765 secs Process 17452) Received: from it-phil.weatherbeeta.com.au (HELO wbaus090) (172.20.0.155) by mail.weatherbeeta.com.au with SMTP; 30 Oct 2007 15:42:58 +1100 From: "Phillip Smith" To: "'Abu Mushayeed'" , Subject: Re: High system CPU usage during query run Date: Tue, 30 Oct 2007 15:43:03 +1100 Organization: Weatherbeeta Pty Ptd Message-ID: <020901c81aaf$5b6258b0$9b0014ac@wbaus090> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_020A_01C81B0B.8ED2D0B0" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.6626 In-Reply-To: <219953.3211.qm@web57110.mail.re3.yahoo.com> Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 X-Scanned-By-wbeetaau1: Virus scan performed by network-box X-Scanned-By-wbeetaau1: Scanner file id is wbeetaau1-1193719385.902-16793-000 X-Scanned-By-wbeetaau1: No known viruses found in message (received+scanned in 0.02/0.05 secs) X-Scanned-By-wbeetaau1: Spam-Check-Result: No, hits=0 required=7 tests= autolearn=no version=2.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/301 X-Sequence-Number: 27215 This is a multi-part message in MIME format. ------=_NextPart_000_020A_01C81B0B.8ED2D0B0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable Is this a Windows or Linux based system? What version of PostgreSQL? = What else is running on the server? =20 =20 -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Abu Mushayeed Sent: Tuesday, 30 October 2007 14:49 To: pgsql-admin@postgresql.org Subject: [ADMIN] High system CPU usage during query run =20 Hello, =20 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. =20 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? =20 Our server has dual core Intel Xeon processors 2.66 GHZ, 16GB RAM and = RAID10 1.5 TB. =20 Please I need advise on this problem. =20 Thanks Abu __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around=20 http://mail.yahoo.com=20 =0ATHINK BEFORE YOU PRINT - Save paper if you don't really need to print this= =0A=0A*******************Confidentiality and Privilege Notice*******************= =0A=0AThe material contained in this message is privileged and confidential to= =0Athe addressee. If you are not the addressee indicated in this message or= =0Aresponsible for delivery of the message to such person, you may not copy=0Aor= deliver this message to anyone, and you should destroy it and kindly=0Anotify= the sender by reply email.=0A=0AInformation in this message that does not relat= e to the official business=0Aof Weatherbeeta must be treated as neither given = nor endorsed by Weatherbeeta.=0AWeatherbeeta, its employees, contractors or as= sociates shall not be liable=0Afor direct, indirect or consequential loss aris= ing from transmission of this=0Amessage or any attachments=0Ae-mail.=0A ------=_NextPart_000_020A_01C81B0B.8ED2D0B0 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable

Is this a Windows or Linux based = system? What version of PostgreSQL? What else is running on the = server?

 

 

-----Original Message-----
From: pgsql-admin-owner@postgresql.org = [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Abu Mushayeed
Sent: Tuesday, 30 October = 2007 14:49
To: = pgsql-admin@postgresql.org
Subject: [ADMIN] High = system CPU usage during query run

 

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


=

=0ATHINK BEFORE YOU PRINT - Save paper if you don't really need to print t= his e-mail.=0A

=0A*******************Confidentiality and Privilege Notice**= *****************=0A

=0AThe material contained in this message is privileg= ed and confidential to=0Athe addressee. If you are not the addressee indicate= d in this message or=0Aresponsible for delivery of the message to such person,= you may not copy=0Aor deliver this message to anyone, and you should destroy = it and kindly=0Anotify the sender by reply email.=0A

=0AInformation in this mess= age that does not relate to the official business=0Aof Weatherbeeta must be tr= eated as neither given nor endorsed by Weatherbeeta.=0AWeatherbeeta, its emplo= yees, contractors or associates shall not be liable=0Afor direct, indirect or = consequential loss arising from transmission of this=0Amessage or any attachme= nts=0A
= ------=_NextPart_000_020A_01C81B0B.8ED2D0B0--