Re: Low CPU Usage - Mailing list pgsql-performance
| From | brauagustin-susc@yahoo.com.ar |
|---|---|
| Subject | Re: Low CPU Usage |
| Date | |
| Msg-id | 129819.36392.qm@web30001.mail.mud.yahoo.com Whole thread Raw |
| In response to | Low CPU Usage (brauagustin-susc@yahoo.com.ar) |
| List | pgsql-performance |
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
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
El Mundial de Rugby 2007
Las últimas noticias en Yahoo! Deportes:
http://ar.sports.yahoo.com/mundialderugby
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
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
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
> 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
El Mundial de Rugby 2007
Las últimas noticias en Yahoo! Deportes:
http://ar.sports.yahoo.com/mundialderugby
pgsql-performance by date: