Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 41FB49F99EA for ; Mon, 24 Sep 2007 11:16:51 -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 89376-01 for ; Mon, 24 Sep 2007 11:16:35 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from web30001.mail.mud.yahoo.com (web30001.mail.mud.yahoo.com [209.191.69.18]) by postgresql.org (Postfix) with SMTP id ADC2E9F983B for ; Mon, 24 Sep 2007 11:16:43 -0300 (ADT) Received: (qmail 37196 invoked by uid 60001); 24 Sep 2007 14:16:39 -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=XI7lQGwyzgBvSTDJYN14zMKsvunUmaR4M3IgmrDOppbm5LpbHCb8Mb1YvKpGvxOtKwb9Wq4fro//d5ATsRRqnHzyKgGUhSq2JtgkYpo5zXE2T+wdPjg9olyvj9sfZJJyuCPM0DikfIk1jEGnvMvS0sJlZpxHaC7RkOKD42TQhKo=; X-YMail-OSG: dtNamMoVM1k3V4RhW_gLEpulYQYG63Q1ELWOQQS_6JX7tENs7Eki.bGZ9p7DA3YLfZi6m3Qx4lUpBcqSVe6QxkHR1fYQgzhUDGNkaHPAKwjF9xJWDXQ- Received: from [209.191.106.123] by web30001.mail.mud.yahoo.com via HTTP; Mon, 24 Sep 2007 07:16:38 PDT X-Mailer: YahooMailRC/651.50 YahooMailWebService/0.7.134 Date: Mon, 24 Sep 2007 07:16:38 -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-397900092-1190643398=:36392" Message-ID: <129819.36392.qm@web30001.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/417 X-Sequence-Number: 26962 --0-397900092-1190643398=:36392 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable I have found the reason!!! I begin to see line by line postgresql.conf and = saw ssl =3D true.=0AI have disabled ssl and then I have restarted the serve= r and that's all. It's 4 or 5 times faster than the old server.=0AI don't u= nderstand why PgAdmin is connecting using ssl if I have leave this field em= pty!!!=0ADebian by default installs Postgres with ssl enabled.=0AThank you = very much all of you to help me to find the causes.=0ARegards=0AAgustin=0A= =0A----- Mensaje original ----=0ADe: "brauagustin-susc@yahoo.com.ar" =0APara: Greg Smith =0ACC: p= gsql-performance@postgresql.org=0AEnviado: lunes 24 de septiembre de 2007, = 10:59:26=0AAsunto: Re: [PERFORM] Low CPU Usage=0A=0AHi Greg this is my Bonn= ie result.=0A=0AVersion 1.03 ------Sequential Output------ --Sequent= ial Input- --Random-=0A -Per Chr- --Block-- -Rewrite- -P= er 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 =0A 0=0A ------Se= quential Create------ --------Random Create--------=0A -= Create-- --Read--- -Delete-- -Create-- --Read--- -Delete--=0A = files /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP=0A = 16 +++++ +++ +++++ +++ +++++ +++ +++++ +++ +++++ +++ +++++ +++=0A= insaubi,8G,25893,54,26762,9,14146,3,36846,68,43502,3,102.8,0,16,+++++,+++,+= ++++,+++,+++++,+++,+++++,+++,+++++,+++,+++++,+++=0A=0AIf I compare this aga= inst my laptop (SATA disk too) is really better, but I don't know if this r= esult is a good one or not.=0AI don't=0A know where to continue looking for= the cause of the problem, I think there is a bug or something missconfigur= ed with Debian 4.0r1 and Postgres.=0AI unppluged the server from the networ= k with the same results. I have the server mapped as localhost in PgAdmin I= II, there shouldn't be network traffic and there isn't (monitoring the netw= ork interface). I'm really lost with this weird behaviour.=0AI really aprec= iate your help=0ARegards=0AAgustin=0A=0A----- Mensaje original ----=0ADe: G= reg 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=0AOn Thu, 20 Sep 200= 7, 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=0A litt= le test hdparm does is not exactly a robust hard drive benchmark. =0AIf you= want to rule out hard drive transfer speed issues, take at look at =0Athe = tests suggested at =0Ahttp://www.westnet.com/~gsmith/content/postgresql/pg-= disktesting.htm and =0Asee how your results compare to the single SATA disk= example I give there.=0A=0A--=0A* Greg Smith gsmith@gregsmith.com http://w= ww.gregsmith.com Baltimore, MD=0A=0A=0A=0A=0A=0A=0A=0A =0AEl Mundial d= e Rugby 2007=0ALas =FAltimas noticias en Yahoo! Deportes:=0A=0Ahttp://ar.sp= orts.yahoo.com/mundialderugby=0A=0A=0A=0A=0A=0A Los referentes m=E1s i= mportantes en compra/ venta de autos se juntaron:=0ADemotores y Yahoo!=0AAh= ora comprar o vender tu auto es m=E1s f=E1cil. Vist=E1 ar.autos.yahoo.com/ --0-397900092-1190643398=:36392 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
I have found the reason!!! I begin to see line by l= ine postgresql.conf and saw ssl =3D true.
I have disabled ssl and then I= have restarted the server and that's all. It's 4 or 5 times faster than th= e old server.
I don't understand why PgAdmin is connecting using ssl if = I have leave this field empty!!!
Debian by default installs Postgres wit= h ssl enabled.
Thank you very much all of you to help me to find the cau= ses.
Regards
Agustin

----- Mensaje original ----
De= : "brauagustin-susc@yahoo.com.ar" <brauagustin-susc@yahoo.com.ar>
= Para: Greg Smith <gsmith@gregsmith.com>
CC: pgsql-performance@postgresql.org
Enviado: lunes 24 de septiembre de 200= 7, 10:59:26
Asunto: Re: [PERFORM] Low CPU Usage

H= i Greg this is my Bonnie result.

Version  1.03   = ;    ------Sequential Output------ --Sequential Input- --Ran= dom-
           &= nbsp;        -Per Chr- --Block-- -Rewrit= e- -Per Chr- --Block-- --Seeks--
Machine     &n= bsp;  Size K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP  /se= c %CP
insaubi          8G 2= 5893  54 26762   9 14146   3 36846  68 43502&= nbsp;  3 102.8  =0A 0
      = ;            &n= bsp; ------Sequential Create------ --------Random Create--------
 &= nbsp;           &nbs= p;      -Create-- --Read--- -Delete-- -Create-- --= Read--- -Delete--
         =      files  /sec %CP  /sec %CP  /sec %CP=   /sec %CP  /sec %CP  /sec %CP
    &n= bsp;            16 += ++++ +++ +++++ +++ +++++ +++ +++++ +++ +++++ +++ +++++ +++
insaubi,8G,25= 893,54,26762,9,14146,3,36846,68,43502,3,102.8,0,16,+++++,+++,+++++,+++,++++= +,+++,+++++,+++,+++++,+++,+++++,+++

If I compare this against my lap= top (SATA disk too) is really better, but I don't know if this result is a = good one or not.
I don't=0A know where to continue looking for the cause= of the problem, I think there is a bug or something missconfigured with De= bian 4.0r1 and Postgres.
I unppluged the server from the network with th= e same results. I have the server mapped as localhost in PgAdmin III, there= shouldn't be network traffic and there isn't (monitoring the network inter= face). I'm really lost with this weird behaviour.
I really apreciate you= r help
Regards
Agustin

----- Mensaje original ----
= De: Greg Smith <gsmith@gregsmith.com>
Para: brauagustin-susc@yahoo= .com.ar
CC: pgsql-performance@postgresql.org
Enviado: s=E1bado 22 de = septiembre de 2007, 3:29:17
Asunto: Re: [PERFORM] Low CPU Usage

<= div>On Thu, 20 Sep 2007, brauagustin-susc@yahoo.com.ar wrote:

> W= hich other test can I do to find if this is a hardware, kernel o
> p= ostgres issue?

The=0A little test hdparm does is not exactly a robus= t hard drive benchmark.
If you want to rule out hard drive transfer spe= ed issues, take at look at
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 Mundi= al de Rugby 2007
Las =FAltimas noticias en Yahoo! Deportes:
=0A= htt= p://ar.sports.yahoo.com/mundialderugby


=0A

El Mund= ial de Rugby 2007
Las =FAltimas noticias en Yahoo! Deportes:
=0Ahttp:= //ar.sports.yahoo.com/mundialderugby --0-397900092-1190643398=:36392--