From: | brauagustin-susc(at)yahoo(dot)com(dot)ar |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Low CPU Usage |
Date: | 2007-09-19 17:38:13 |
Message-ID: | 65712.86940.qm@web30004.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hi all.
Recently I have installed a brand new server with a Pentium IV 3.2 GHz, SATA Disk, 2GB of Ram in Debian 4.0r1 with PostgreSQL 8.2.4 (previously a 8.1.9).
I have other similar server with an IDE disk, Red Hat EL 4 and PostgreSQL 8.2.3
I have almost the same postgresql.conf in both servers, but in the new one (I have more work_mem than the other one) things go really slow. I began to monitor i/o disk and it's really ok, I have test disk with hdparm and it's 5 times faster than the IDE one.
Running the same queries in both servers in the new one it envolves almost 4 minutes instead of 18 seconds in the old one.
Both databases are the same, I have vacuum them and I don't know how to manage this issue.
The only weird thing is than in the older server running the query it uses 30% of CPU instead of 3 o 5 % of the new one!!!
What's is happening with this server? I upgrade from 8.1.9 to 8.2.4 trying to solve this issue but I can't find a solution.
Any ideas?
Regards
Agustin
Seguí de cerca a la Selección Argentina de Rugby en el Mundial de Francia 2007.
http://ar.sports.yahoo.com/mundialderugby
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2007-09-19 17:52:51 | Re: Low CPU Usage |
Previous Message | Carlos Moreno | 2007-09-19 15:58:18 | Tablespaces and NFS |