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 wit
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
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 dat
hi,
I have two computers, one laptop (1.5 GHz, 512 Mb RAM, 1 disk 4200)
and one big Sun (8Gb RAM, 2 disks SCSI).
On my laptop, I have this EXPLAIN ANALYZE
Sort (cost=7.56..7.56 rows=1 width=28) (actual time=0.187..0.187
rows=0 loops=1)
Sort Key: evolution, indx
-> Index Scan using index
