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
Jean-Max,
I have two computers, one laptop (1.5 GHz, 512 Mb RAM, 1 disk 4200)
and one big Sun (8Gb RAM, 2 disks SCSI).
Did you run each query several times? It looks like the index is cached
on one server and not on the other.
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco
Jean-Max Reymond [EMAIL PROTECTED] writes:
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.
Are you sure they're both vacuumed? The Sun machine's behavior seems
consistent with