Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 1486B9F9B27 for ; Thu, 20 Sep 2007 08:31:07 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 46481-03 for ; Thu, 20 Sep 2007 08:30:50 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from web30010.mail.mud.yahoo.com (web30010.mail.mud.yahoo.com [209.191.69.27]) by postgresql.org (Postfix) with SMTP id CEF459F9B04 for ; Thu, 20 Sep 2007 08:30:54 -0300 (ADT) Received: (qmail 58169 invoked by uid 60001); 20 Sep 2007 11:30:53 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.ar; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:MIME-Version:Content-Type:Message-ID; b=jB92uVvrwIr2T33f2mB6qkB4LbYX2aljGK1iSm87ilSGjORB7EwuZgGr/z8Y4pTdto7p7I5FfZhTyzP5+7brniXRpCMLjqJDGzyPa+fmiwiOEHsgPGy39pLUgBGK4djdW7RqmmxIq25lpEAOBgJPTGF6ao726j7Apkdk5RSue0I=; X-YMail-OSG: Yhw_4h4VM1mx2PPo6tzps0wAJd6KarC7w6Wy_4a99kenfaA1l9yHzeVm7YiCWMnDjU4Y3BJf3YFkIIXeR90jAez6NXg9PEitVj4s9DLV_sX_AEPTAKzpVLcU3UJEQw-- Received: from [68.142.201.145] by web30010.mail.mud.yahoo.com via HTTP; Thu, 20 Sep 2007 04:30:53 PDT X-Mailer: YahooMailRC/651.50 YahooMailWebService/0.7.134 Date: Thu, 20 Sep 2007 04:30:53 -0700 (PDT) From: brauagustin-susc@yahoo.com.ar Subject: Re: Low CPU Usage To: Norberto Meijome Cc: pgsql-performance@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1393920195-1190287853=:56511" Message-ID: <311295.56511.qm@web30010.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.002 tagged_above=0 required=5 tests=BAYES_50=0.001, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200709/327 X-Sequence-Number: 26872 --0-1393920195-1190287853=:56511 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hola Beto.=0AI have no idea where to look for that configuration or setting= s.=0AYesterday I red about some drivers problems with SATA disk working tog= heter with IDE devices with DMA.=0A=0AMi server server is a Pentium VI 3.3 = with hyper threading (enabled in BIOS), HP Proliant ML 110.=0A=0AThen I ent= ered to the BIOS and saw in IDE Configuration: =0A ATA/IDE Configuration = [Enhanced]=0A Configure SATA as = [IDE] =3D> it has RAID option too=0A=0AI have any idea how to continue!!= ! I don't know if this a SATA problem, a configuration problem or what else= . I have installed several servers beggining with postgres 6.4 and I've nev= ed had this kind of problems (always with IDE disks). I think this is a pro= blem with SATA disk i/o, but I don't see how to measure that (I have alread= y set postgresql.conf).=0A=0ARegards=0AAgustin=0A=0A=0A----- Mensaje origin= al ----=0ADe: Norberto Meijome =0APara: brauagustin-s= usc@yahoo.com.ar=0ACC: pgsql-performance@postgresql.org=0AEnviado: jueves 2= 0 de septiembre de 2007, 7:53:05=0AAsunto: Re: [PERFORM] Low CPU Usage=0A= =0AOn Wed, 19 Sep 2007 12:13:33 -0700 (PDT)=0Abrauagustin-susc@yahoo.com.ar= wrote:=0A=0A> max_stack_depth =3D 7MB #in the old server is 8MB but if I s= et in here give me the ulimit error=0A=0AHola Agustin :)=0Aotro argentino e= n el extranjero x aca ;) =0A=0Aanyway, back to English ;)=0A=0Aa long shot = but...=0A=0Acheck if you have any limits set on the host for CPU usage... y= ou may be=0Alimited to x number of secs / % by the OS scheduler. When you q= uery your CPU,=0Ait will say u are only using 5% or so... =0A=0Achau,=0ABet= o=0A=0A_________________________=0ANorberto Meijome=0AOctantis Pty Ltd=0A= =0AIntelligence: Finding an error in a Knuth text.=0AStupidity: Cashing tha= t $2.56 check you got.=0A=0A=0A=0A=0ANOTICE: The contents of this email and= its attachments are confidential and=0Aintended only for the individuals o= r entities named above. If you have received=0Athis message in error, pleas= e advise the sender by reply email and immediately=0Adelete the message and= any attachments without using, copying or disclosing the=0Acontents. Thank= you.=0A=0A=0A=0A=0A=0A=0A=0A Los referentes m=E1s importantes en comp= ra/ venta de autos se juntaron:=0ADemotores y Yahoo!=0AAhora comprar o vend= er tu auto es m=E1s f=E1cil. Vist=E1 ar.autos.yahoo.com/ --0-1393920195-1190287853=:56511 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Hola Beto.
I have no idea where to look for that= configuration or settings.
Yesterday I red about some drivers problems = with SATA disk working togheter with IDE devices with DMA.

Mi server= server is a Pentium VI 3.3 with hyper threading (enabled in BIOS), HP Prol= iant ML 110.

Then I entered to the BIOS and saw in IDE Configuration= :
  ATA/IDE Configuration       = ;             [= Enhanced]
          Configu= re SATA as           = ;        [IDE]  =3D> it has RAID option too

I have any idea how to continue!!! I don't know if this = a SATA problem, a configuration problem or what else. I have installed seve= ral servers beggining with postgres 6.4 and I've neved had this kind of pro= blems (always with IDE disks). I think this is a problem with SATA disk i/o= , but I don't see how to measure that (I have already set postgresql.conf).=

Regards
Agustin


----- Mensaje original ----De: Norberto Meijome <beto@octantis.com.au>
Para: brauagustin-su= sc@yahoo.com.ar
CC: pgsql-performance@postgresql.org
Enviado: jueves = 20 de septiembre de 2007, 7:53:05
Asunto: Re: [PERFORM] Low CPU Usage
On Wed, 19 Sep 2007 12:13:33 -0700 (PDT)
brauagustin-susc@yaho= o.com.ar wrote:

> max_stack_depth =3D 7MB #in the old server is 8= MB but if I set in here give me the ulimit error

Hola Agustin :)
otro argentino en el extranjero x aca ;)

anyway, back to Eng= lish ;)

a long shot but...

check if you have any limits set o= n the host for CPU usage... you may be
limited to x number of secs / % b= y the OS scheduler. When you query your CPU,
it will say u are only usin= g 5% or so...

chau,
Beto

_________________________
Nor= berto Meijome
Octantis Pty Ltd

Intelligence: Finding an error in = a Knuth text.
Stupidity: Cashing that $2.56 check you got.



NOTICE: The contents of this email and its attachments are confidenti= al and
intended only for the individuals or entities named above. If you= have received
this message in error, please advise the sender by reply = email and immediately
delete the message and any attachments without usi= ng, copying or disclosing the
contents. Thank you.


=0A

= El Mundial de Rugby 2007
Las =FAltimas noticias en Yahoo! Deportes:
= =0Ahttp://ar.sports.yahoo.com/mundialderugby --0-1393920195-1190287853=:56511--