Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id F215D9F9867 for ; Mon, 24 Sep 2007 10:59:32 -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 80166-03 for ; Mon, 24 Sep 2007 10:59:28 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from web30015.mail.mud.yahoo.com (web30015.mail.mud.yahoo.com [209.191.69.32]) by postgresql.org (Postfix) with SMTP id 415719F972D for ; Mon, 24 Sep 2007 10:59:28 -0300 (ADT) Received: (qmail 18858 invoked by uid 60001); 24 Sep 2007 13:59:26 -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=ohL2O9hkpwJdlu1ZdUfHG43654lzJmn97rWvBvYuoyDxLh7iFhb3ksmEawWyVVxvWAYo5MxKkgRPHEqRKPmHrw1XL66TzTl3+FZrTrE7Jr9CA2dN00oUMseOFaD+iqYc//Epq42nwvhS2Ae9s8IJnMw20ZO/Z/Y3aFOMoHB/GME=; X-YMail-OSG: JXS7A2cVM1kJVbwi3jr.DJ2ZZ1s_d2ZbLRo.PqyLWQ9qUy0K6y6GFpsAp70f6Re_8hH6jTuQ_nV_yv0p3qNqBgmCGDj.tggtMMgOuObdIY_SnwIFb0M- Received: from [209.191.106.127] by web30015.mail.mud.yahoo.com via HTTP; Mon, 24 Sep 2007 06:59:26 PDT X-Mailer: YahooMailRC/651.50 YahooMailWebService/0.7.134 Date: Mon, 24 Sep 2007 06:59:26 -0700 (PDT) From: brauagustin-susc@yahoo.com.ar Subject: Re: Low CPU Usage To: Greg Smith Cc: pgsql-performance@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-236159941-1190642366=:18731" Message-ID: <425702.18731.qm@web30015.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/414 X-Sequence-Number: 26959 --0-236159941-1190642366=:18731 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hi Greg this is my Bonnie result.=0A=0AVersion 1.03 ------Sequential= Output------ --Sequential Input- --Random-=0A -Per Chr-= --Block-- -Rewrite- -Per Chr- --Block-- --Seeks--=0AMachine Size K/= sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP /sec %CP=0Ainsaubi = 8G 25893 54 26762 9 14146 3 36846 68 43502 3 102.8 0=0A = ------Sequential Create------ --------Random Create--------=0A = -Create-- --Read--- -Delete-- -Create-- --Read--- -Delet= e--=0A files /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP= /sec %CP=0A 16 +++++ +++ +++++ +++ +++++ +++ +++++ +++ ++= +++ +++ +++++ +++=0Ainsaubi,8G,25893,54,26762,9,14146,3,36846,68,43502,3,10= 2.8,0,16,+++++,+++,+++++,+++,+++++,+++,+++++,+++,+++++,+++,+++++,+++=0A=0AI= f I compare this against my laptop (SATA disk too) is really better, but I = don't know if this result is a good one or not.=0AI don't know where to con= tinue looking for the cause of the problem, I think there is a bug or somet= hing missconfigured with Debian 4.0r1 and Postgres.=0AI unppluged the serve= r from the network with the same results. I have the server mapped as local= host in PgAdmin III, there shouldn't be network traffic and there isn't (mo= nitoring the network interface). I'm really lost with this weird behaviour.= =0AI really apreciate your help=0ARegards=0AAgustin=0A=0A----- Mensaje orig= inal ----=0ADe: Greg Smith =0APara: brauagustin-susc@= yahoo.com.ar=0ACC: pgsql-performance@postgresql.org=0AEnviado: s=E1bado 22 = de septiembre de 2007, 3:29:17=0AAsunto: Re: [PERFORM] Low CPU Usage=0A=0AO= n Thu, 20 Sep 2007, brauagustin-susc@yahoo.com.ar wrote:=0A=0A> Which other= test can I do to find if this is a hardware, kernel o =0A> postgres issue?= =0A=0AThe little test hdparm does is not exactly a robust hard drive benchm= ark. =0AIf you want to rule out hard drive transfer speed issues, take at l= ook at =0Athe tests suggested at =0Ahttp://www.westnet.com/~gsmith/content/= postgresql/pg-disktesting.htm and =0Asee how your results compare to the si= ngle SATA disk example I give there.=0A=0A--=0A* Greg Smith gsmith@gregsmit= h.com http://www.gregsmith.com Baltimore, MD=0A=0A=0A=0A=0A=0A=0A=0A L= as =FAltimas noticias sobre el Mundial de Rugby 2007 est=E1n en Yahoo! Depo= rtes. =A1Conocelas!=0Ahttp://ar.sports.yahoo.com/mundialderugby --0-236159941-1190642366=:18731 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Hi Greg this is my Bonnie result.

Version&nb= sp; 1.03       ------Sequential Output------ = --Sequential Input- --Random-
       =              -P= er Chr- --Block-- -Rewrite- -Per Chr- --Block-- --Seeks--
Machine &= nbsp;      Size K/sec %CP K/sec %CP K/sec %CP K/se= c %CP K/sec %CP  /sec %CP
insaubi     &nbs= p;    8G 25893  54 26762   9 14146  = ; 3 36846  68 43502   3 102.8   0
           &nb= sp;        ------Sequential Create------= --------Random Create--------
       = ;             -= Create-- --Read--- -Delete-- -Create-- --Read--- -Delete--
  &= nbsp;           files&nbs= p; /sec %CP  /sec %CP  /sec %CP  /sec %CP  /sec %CP&nbs= p; /sec %CP
          =        16 +++++ +++ +++++ +++ +++++ +++ +++++= +++ +++++ +++ +++++ +++
insaubi,8G,25893,54,26762,9,14146,3,36846,68,43= 502,3,102.8,0,16,+++++,+++,+++++,+++,+++++,+++,+++++,+++,+++++,+++,+++++,++= +

If I compare this against my laptop (SATA disk too) is really bett= er, but I don't know if this result is a good one or not.
I don't know where to continue looking for the cause of the problem, I think there= is a bug or something missconfigured with Debian 4.0r1 and Postgres.
I = unppluged the server from the network with the same results. I have the ser= ver mapped as localhost in PgAdmin III, there shouldn't be network traffic = and there isn't (monitoring the network interface). I'm really lost with th= is weird behaviour.
I really apreciate your help
Regards
Agustin
----- Mensaje original ----
De: Greg Smith <gsmith@greg= smith.com>
Para: brauagustin-susc@yahoo.com.ar
CC: pgsql-performan= ce@postgresql.org
Enviado: s=E1bado 22 de septiembre de 2007, 3:29:17Asunto: Re: [PERFORM] Low CPU Usage

On Thu, 20 Sep 2007, braua= gustin-susc@yahoo.com.ar wrote:

> Which other test can I do to fi= nd if this is a hardware, kernel o
> postgres issue?

The little test hdparm does is not exactly a robust hard drive benchmark.
= If you want to rule out hard drive transfer speed issues, take at look at <= br>the tests suggested at
http://www.westnet.= com/~gsmith/content/postgresql/pg-disktesting.htm and
see how your = results compare to the single SATA disk example I give there.

--
= * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

=0A

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