2005/6/30, Jean-Max Reymond <[EMAIL PROTECTED]>: > so the request run in 26.646 ms on the Sun and 0.469ms on my laptop :-( > the database are the same, vacuumed and I think the Postgres (8.0.3) > are well configured. > The Sun has two disks and use the TABLESPACE to have index on one disk > and data's on the other disk. > It seems that the cost of the first sort is very high on the Sun. > How is it possible ?
may be data's not loaded in memory but on disk ? -- Jean-Max Reymond CKR Solutions Open Source Nice France http://www.ckr-solutions.com ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])