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: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> Para: Greg Smith <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> Para: [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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/