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?
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?
Marc