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) ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org