Re: slow server

More info on this problem ...

The Query: select acc.expiringCredits, acc.earnedCredits,
acc.purchasedCredits,
acc.statusid, acc.expired from accounts acc, gateways g where
g.gwnumber =  '02000000' and g.accountid = acc.accountid ;
_________________
- PIII system. (returns results in .75 seconds per query)
 PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66

running on RedHat 6.2 (with Kernel 2.2.16)

Merge Join  (cost=8.30..80.93 rows=100 width=25)
  ->  Index Scan using accounts_accountid_key on accounts acc
(cost=0.00..60.00 rows=1000 width=21)
  ->  Sort  (cost=8.30..8.30 rows=10 width=4)
        ->  Index Scan using gateways_gwnumber_key on gateways g
(cost=0.00..8.14 rows=10 width=4)
________________
Celeron system (returns results in .002 seconds per query)
 PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc 2.96

running on RedHat 7.0

Merge Join  (cost=8.30..80.93 rows=100 width=25)
  ->  Index Scan using accounts_accountid_key on accounts acc
(cost=0.00..60.00 rows=1000 width=21)
  ->  Sort  (cost=8.30..8.30 rows=10 width=4)
        ->  Index Scan using gateways_gwnumber_key on gateways g
(cost=0.00..8.14 rows=10 width=4)

 I hope this can shed light somewhere. I'm need a starting point where I
should start looking. I don't understand why Postgres 7.03 would be so much
slower than 7.02.

Marc

Tom Lane wrote:

> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)