From: | Jean-Max Reymond <jmreymond(at)gmail(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Surprizing performances for Postgres on Centrino |
Date: | 2005-07-07 12:49:05 |
Message-ID: | 4b09a0c05070705495df28801@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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,
- 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 ?
Some tips to speed up Postgres on non-Centrino processors ?
--
Jean-Max Reymond
CKR Solutions Open Source
Nice France
http://www.ckr-solutions.com
From | Date | Subject | |
---|---|---|---|
Next Message | PFC | 2005-07-07 12:55:28 | Re: How to speed up delete |
Previous Message | Jean-Max Reymond | 2005-07-07 12:42:08 |