Re: [PERFORM] Surprizing performances for Postgres on Centrino

2005-07-07 Thread Richard Huxton
Jean-Max Reymond wrote: On 7/7/05, Alvaro Herrera <[EMAIL PROTECTED]> wrote: Do you have the same locale settings on all of them? interressant: UNICODE on the fast laptop SQL_ASCII on the slowest desktops. is UNICODE database faster than SQL_ASCII ? That's your encoding (character-set).

Re: [PERFORM] Surprizing performances for Postgres on Centrino

2005-07-07 Thread Jean-Max Reymond
On 7/7/05, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > > Do you have the same locale settings on all of them? > interressant: UNICODE on the fast laptop SQL_ASCII on the slowest desktops. is UNICODE database faster than SQL_ASCII ? -- Jean-Max Reymond CKR Solutions Open Source Nice France htt

Re: [PERFORM] Surprizing performances for Postgres on Centrino

2005-07-07 Thread Alvaro Herrera
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

Re: [PERFORM] Surprizing performances for Postgres on Centrino

2005-07-07 Thread Steinar H. Gunderson
On Thu, Jul 07, 2005 at 03:48:06PM +0200, Dawid Kuroczko wrote: > This is why AMD stopped giving GHz ratings and instead uses numbers > which indicate how their processor relate to Pentium 4s. For instance > AMD Athlon XP 1700+ is running at 1.45 GHz, but competes with > Pentium 4 1.7 GHz. Actual

Re: [PERFORM] Surprizing performances for Postgres on Centrino

2005-07-07 Thread Dawid Kuroczko
On 7/7/05, Jean-Max Reymond <[EMAIL PROTECTED]> wrote: > 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 ( WXP better > tan Linux ;-) ) [...] > I test CPU, memory performance on my laptop and it seems that the

[PERFORM] Surprizing performances for Postgres on Centrino

2005-07-07 Thread Jean-Max Reymond
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 1h