| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Marc Wrubleski <mlwruble(at)sorexsoftware(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: slow server |
| Date: | 2001-04-03 18:47:47 |
| Message-ID: | 6680.986323667@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Marc Wrubleski <mlwruble(at)sorexsoftware(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Wolfe | 2001-04-03 18:52:47 | Re: slow server |
| Previous Message | Tom Lane | 2001-04-03 18:45:25 | Re: libpq bug? (I guess not) |