[prev in list] [next in list] [prev in thread] [next in thread]
List: pgsql-performance
Subject: Re: [PERFORM] Low CPU Usage
From: brauagustin-susc () yahoo ! com ! ar
Date: 2007-09-24 14:16:38
Message-ID: 129819.36392.qm () web30001 ! mail ! mud ! yahoo ! com
[Download RAW message or body]
I have found the reason!!! I begin to see line by line postgresql.conf and saw ssl = \
true. I have disabled ssl and then I have restarted the server and that's all. It's 4 \
or 5 times faster than the old server. I don't understand why PgAdmin is connecting \
using ssl if I have leave this field empty!!! Debian by default installs Postgres \
with ssl enabled. Thank you very much all of you to help me to find the causes.
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 2007, 10:59:26
Asunto: Re: [PERFORM] Low CPU Usage
Hi Greg this is my Bonnie result.
Version 1.03 ------Sequential Output------ --Sequential Input- --Random-
-Per Chr- --Block-- -Rewrite- -Per Chr- --Block-- --Seeks--
Machine Size K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP /sec %CP
insaubi 8G 25893 54 26762 9 14146 3 36846 68 43502 3 102.8
0
------Sequential Create------ --------Random Create--------
-Create-- --Read--- -Delete-- -Create-- --Read--- -Delete--
files /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP
16 +++++ +++ +++++ +++ +++++ +++ +++++ +++ +++++ +++ +++++ +++
insaubi,8G,25893,54,26762,9,14146,3,36846,68,43502,3,102.8,0,16,+++++,+++,+++++,+++,+++++,+++,+++++,+++,+++++,+++,+++++,+++
If 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. 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 server 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 this weird behaviour. I really apreciate \
your help Regards
Agustin
----- Mensaje original ----
De: Greg Smith <gsmith@gregsmith.com>
Para: brauagustin-susc@yahoo.com.ar
CC: pgsql-performance@postgresql.org
Enviado: sábado 22 de septiembre de 2007, 3:29:17
Asunto: Re: [PERFORM] Low CPU Usage
On Thu, 20 Sep 2007, brauagustin-susc@yahoo.com.ar wrote:
> Which other test can I do to find 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
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
El Mundial de Rugby 2007
Las últimas noticias en Yahoo! Deportes:
http://ar.sports.yahoo.com/mundialderugby
Los referentes más importantes en compra/ venta de autos se juntaron:
Demotores y Yahoo!
Ahora comprar o vender tu auto es más fácil. Vistá ar.autos.yahoo.com/
[Attachment #3 (text/html)]
<html><head><style type="text/css"><!-- DIV {margin:0px;} \
--></style></head><body><div style="font-family:times new roman, new york, times, \
serif;font-size:12pt"><div style="font-family: times new roman,new york,times,serif; \
font-size: 12pt;">I have found the reason!!! I begin to see line by line \
postgresql.conf and saw ssl = true.<br>I have disabled ssl and then I have restarted \
the server and that's all. It's 4 or 5 times faster than the old server.<br>I don't \
understand why PgAdmin is connecting using ssl if I have leave this field \
empty!!!<br>Debian by default installs Postgres with ssl enabled.<br>Thank you very \
much all of you to help me to find the causes.<br>Regards<br>Agustin<br><br><div \
style="font-family: times new roman,new york,times,serif; font-size: 12pt;">----- \
Mensaje original ----<br>De: "brauagustin-susc@yahoo.com.ar" \
<brauagustin-susc@yahoo.com.ar><br>Para: Greg Smith \
<gsmith@gregsmith.com><br>CC: pgsql-performance@postgresql.org<br>Enviado: \
lunes 24 de septiembre de 2007, 10:59:26<br>Asunto: Re: [PERFORM] Low CPU \
Usage<br><br><div style="font-family: times new roman,new york,times,serif; \
font-size: 12pt;"><div style="font-family: times new roman,new york,times,serif; \
font-size: 12pt;">Hi Greg this is my Bonnie result.<br><br>Version \
1.03 ------Sequential Output------ --Sequential \
Input- --Random-<br> \
-Per Chr- --Block-- -Rewrite- -Per Chr- --Block-- \
--Seeks--<br>Machine Size K/sec %CP K/sec \
%CP K/sec %CP K/sec %CP K/sec %CP /sec \
%CP<br>insaubi 8G 25893 \
54 26762 9 14146 3 36846 68 43502 3 \
102.8 0<br> \
------Sequential Create------ --------Random \
Create--------<br> \
-Create-- --Read--- -Delete-- -Create-- --Read--- \
-Delete--<br> \
files /sec %CP /sec %CP /sec %CP /sec %CP /sec \
%CP /sec %CP<br> \
16 +++++ +++ +++++ +++ +++++ +++ +++++ +++ +++++ +++ +++++ \
+++<br>insaubi,8G,25893,54,26762,9,14146,3,36846,68,43502,3,102.8,0,16,+++++,+++,+++++,+++,+++++,+++,+++++,+++,+++++,+++,+++++,+++<br><br>If \
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.<br>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.<br>I unppluged the server from the network with the 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 interface). I'm really lost \
with this weird behaviour.<br>I really apreciate your \
help<br>Regards<br>Agustin<br><br><div style="font-family: times new roman,new \
york,times,serif; font-size: 12pt;">----- Mensaje original ----<br>De: Greg Smith \
<gsmith@gregsmith.com><br>Para: brauagustin-susc@yahoo.com.ar<br>CC: \
pgsql-performance@postgresql.org<br>Enviado: sábado 22 de septiembre de 2007, \
3:29:17<br>Asunto: Re: [PERFORM] Low CPU Usage<br><br><div>On Thu, 20 Sep 2007, \
brauagustin-susc@yahoo.com.ar wrote:<br><br>> Which other test can I do to find if \
this is a hardware, kernel o <br>> postgres issue?<br><br>The little test hdparm \
does is not exactly a robust hard drive benchmark. <br>If you want to rule out hard \
drive transfer speed issues, take at look at <br>the tests suggested at <br><a \
rel="nofollow" target="_blank" \
href="http://www.westnet.com/%7Egsmith/content/postgresql/pg-disktesting.htm">http://www.westnet.com/~gsmith/content/postgresql/pg-disktesting.htm</a> \
and <br>see how your results compare to the single SATA disk example I give \
there.<br><br>--<br>* Greg Smith gsmith@gregsmith.com <a rel="nofollow" \
target="_blank" href="http://www.gregsmith.com">http://www.gregsmith.com</a> \
Baltimore, MD<br></div></div><br></div></div><br>
<hr size="1"><br><font face="Verdana" size="-2">El Mundial de Rugby 2007<br>Las \
últimas noticias en Yahoo! Deportes:<br><span> <a target="_blank" \
href="http://ar.sports.yahoo.com/mundialderugby">http://ar.sports.yahoo.com/mundialderugby</a></span></font></div><br></div></div><br>
<hr size=1><br><font face="Verdana" size="-2">El Mundial de Rugby 2007<br>Las \
últimas noticias en Yahoo! Deportes:<br> \
http://ar.sports.yahoo.com/mundialderugby</font></body></html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic