Marc Wrubleski <mlwruble@sorexsoftware.com> writes:
> Hi, I have two systems one is a 500Mhz Celeron with 128 MB ram and IDE
> Disks, the other is 800Mhz PIII, 512MB RAM, SCSI Disks.
> Obviously the PIII should stomp on the performance of the Celeron, but
> my postgres installation on the faster system is MUCH slower.
> I simple query on two tables joined on the celeron takes about .002
> seconds. On the PIII it takes .75 seconds. Same Query, same tables, same
> indexes. The results from explain are the same. the results from the
> query are the same.
> Any Ideas?
You've managed to tell us absolutely *nothing* of value here. What
Postgres version, what queries, what query plans exactly?
> One thing to think about is the PIII was installed via RPM and the
> Celeron wass compiled on that machine. Could this be the limiting
> factor?
Kinda makes me wonder if they are different PG versions and/or different
configuration options ...
regards, tom lane