Re: slow server

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