Re: Surprizing performances for Postgres on Centrino

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Surprizing performances for Postgres on Centrino
Дата
Msg-id 20050707140934.GB6139@alvh.no-ip.org
обсуждение исходный текст
Ответ на Surprizing performances for Postgres on Centrino  (Jean-Max Reymond <jmreymond@gmail.com>)
Ответы Re: Surprizing performances for Postgres on Centrino  (Jean-Max Reymond <jmreymond@gmail.com>)
Список pgsql-performance
On Thu, Jul 07, 2005 at 02:49:05PM +0200, Jean-Max Reymond wrote:
> 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

Do you have the same locale settings on all of them?

--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"We are who we choose to be", sang the goldfinch
when the sun is high (Sandman)

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Steinar H. Gunderson"
Дата:
Сообщение: Re: Surprizing performances for Postgres on Centrino
Следующее
От: Jean-Max Reymond
Дата:
Сообщение: Re: Surprizing performances for Postgres on Centrino