DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition;
	b=b9rqCUvtOM1OWWIL5dfvlnm6HBcH/w8CxJToeG14i60NpSLqaOGlSJUj0OklPN5djx2MSCWHECDQTWJVAhGGrJj1N0YzqQCe2Uip3CtOWAYVSOK67UyM1A3njLnXlmLQ0YhmvR/gohVY5bhN71u/FcCR209Nr1htluMCPctuy6w=
Message-ID: <4b09a0c0507070542fd0d197@mail.gmail.com>
Date: Thu, 7 Jul 2005 14:42:08 +0200
From: Jean-Max Reymond <jmreymond@gmail.com>
Reply-To: Jean-Max Reymond <jmreymond@gmail.com>
To: pgsql-performance@postgresql.org
Subject: 
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi,
These last two days, I have some troubles with a very strange phenomena:
I have a 400 Mb database and a stored procedure written in perl which
call 14 millions times spi_exec_query (thanks to Tom to fix the memory
leak ;-) ).
On my laptop whith Centrino 1.6 GHz, 512 Mb RAM,
 - it is solved in 1h50' for Linux 2.6
 - it is solved in 1h37' for WXP Professionnal (<troll on> WXP better
tan Linux ;-) <troll off>)
On a Desktop with PIV 2.8 GHz,=20
 - it is solved in 3h30 for W2K
On a Desktop with PIV 1.8 GHz, two disks with data and index's on each disk
 - it is solved in 4h for W2K

I test CPU, memory performance on my laptop and it seems that the
performances are not perfect except for one single  test: String sort.

So, it seems that for my application (database in memory, 14 millions
of very small requests), Centrino (aka Pentium M) has a build-in
hardware to boost Postgres performance :-)
Any experience to confirm this fact ?

--=20
Jean-Max Reymond
CKR Solutions Open Source
Nice France
http://www.ckr-solutions.com