Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 7BE1D9F9B61
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 19 Sep 2007 14:45:00 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 98824-07 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 19 Sep 2007 14:44:57 -0300 (ADT)
X-Greylist: delayed 00:06:40.494208 by SQLgrey-1.7.5
Received: from web30004.mail.mud.yahoo.com (web30004.mail.mud.yahoo.com
	[209.191.69.21]) by postgresql.org (Postfix) with SMTP id 0B3689F9AF7
	for <pgsql-performance@postgresql.org>;
	Wed, 19 Sep 2007 14:44:55 -0300 (ADT)
Received: (qmail 87336 invoked by uid 60001); 19 Sep 2007 17:38:14 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.ar;
	h=Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID;
	b=GWsuE9Ty+gBgsjbQhuJ8kf1zoYS6jDZZLpj4nuoeqS1fGNIaj83GbcK/uQ5U1V/row4a49KclkrTlA5h+Ru5e1lOP2XXICp82knX2kpduDZNG3cJRaWCSTV4gyjH7cLreiQmriH88knRmXUIW0WbJ2t+kfPB3Jn8z3y+80oNlYU=;
Received: from [209.191.106.123] by web30004.mail.mud.yahoo.com via HTTP;
	Wed, 19 Sep 2007 10:38:13 PDT
X-Mailer: YahooMailRC/651.50 YahooMailWebService/0.7.134
Date: Wed, 19 Sep 2007 10:38:13 -0700 (PDT)
From: brauagustin-susc@yahoo.com.ar
Subject: Low CPU Usage
To: pgsql-performance@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1326638858-1190223493=:86940"
Message-ID: <65712.86940.qm@web30004.mail.mud.yahoo.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200709/318
X-Sequence-Number: 26863

--0-1326638858-1190223493=:86940
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hi all.=0ARecently 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 (previou=
sly a 8.1.9).=0AI have other similar server with an IDE disk, Red Hat EL 4 =
and PostgreSQL 8.2.3=0A=0AI have almost the same postgresql.conf in both se=
rvers, 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 tes=
t disk with hdparm and it's 5 times faster than the IDE one.=0ARunning the =
same queries in both servers in the new one it envolves almost 4 minutes in=
stead of 18 seconds in the old one.=0ABoth databases are the same, I have v=
acuum them and I don't know how to manage this issue.=0AThe only weird thin=
g is than in the older server running the query it uses 30% of CPU instead =
of 3 o 5 % of the new one!!!=0AWhat's is happening with this server? I upgr=
ade from 8.1.9 to 8.2.4 trying to solve this issue but I can't find a solut=
ion.=0A=0AAny ideas?=0ARegards=0AAgustin=0A=0A=0A=0A=0A      Segu=ED de cer=
ca a la Selecci=F3n Argentina de Rugby en el Mundial de Francia 2007.=0Ahtt=
p://ar.sports.yahoo.com/mundialderugby
--0-1326638858-1190223493=:86940
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

<html><head><style type=3D"text/css"><!-- DIV {margin:0px;} --></style></he=
ad><body><div style=3D"font-family:times new roman, new york, times, serif;=
font-size:12pt"><div>Hi all.<br>Recently I have installed a brand new serve=
r with a Pentium IV 3.2 GHz, SATA Disk, 2GB of Ram in Debian 4.0r1 with Pos=
tgreSQL 8.2.4 (previously a 8.1.9).<br>I have other similar server with an =
IDE disk, Red Hat EL 4 and PostgreSQL 8.2.3<br><br>I have almost the same p=
ostgresql.conf in both servers, but in the new one (I have more work_mem th=
an the other one) things go really slow.&nbsp; I began to monitor i/o disk =
and it's really ok, I have test disk with hdparm and it's 5 times faster th=
an the IDE one.<br>Running the same queries in both servers in the new one =
it envolves almost 4 minutes instead of 18 seconds in the old one.<br>Both =
databases are the same, I have vacuum them and I don't know how to manage t=
his issue.<br>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!!!<br>What'=
s is happening with this server? I upgrade from 8.1.9 to 8.2.4 trying to so=
lve this issue but I can't find a solution.<br><br>Any ideas?<br>Regards<br=
>Agustin<br></div></div><br>=0A      <hr size=3D1><br><font face=3D"Verdana=
" size=3D"-2">El Mundial de Rugby 2007<br>Las =FAltimas noticias en Yahoo! =
Deportes:<br>=0Ahttp://ar.sports.yahoo.com/mundialderugby</font></body></ht=
ml>
--0-1326638858-1190223493=:86940--