Re: pg 8.1.3, AIX, huge box, painfully slow. - Mailing list pgsql-performance

From Gábriel Ákos
Subject Re: pg 8.1.3, AIX, huge box, painfully slow.
Date
Msg-id 4436CE0D.6010702@i-logic.hu
Whole thread Raw
In response to pg 8.1.3, AIX, huge box, painfully slow.  (Gavin Hamill <gdh@laterooms.com>)
List pgsql-performance
Gavin Hamill wrote:
> Bing-bong, passenger announcement.. the panic train is now pulling into
> platform 8.1.3. Bing-bong. =)
>
> OK, having moved from our quad-xeon to an 8-CPU IBM pSeries 650
> (8x1.45GHz POWER4 instead of 4 x 3GHz Xeon), our query times have shot
> up and our website is next to unusable. The IBM is not swapping (not

I would say running _one_ query at a time depends on the power of _one_
cpu. PPCs aren't that fast, I'd say they are slower than Xeons. Moreover
I'm sure that AMD Opterons are faster than Xeons. I'd say you should go
and test an opteron-based configuration. You'll get much more power for
the same (much likely for less) money.


--
Üdvözlettel,
Gábriel Ákos
-=E-Mail :akos.gabriel@i-logic.hu|Web:  http://www.i-logic.hu=-
-=Tel/fax:+3612367353            |Mobil:+36209278894            =-

pgsql-performance by date:

Previous
From: Greg Stark
Date:
Subject: Re: pg 8.1.3, AIX, huge box, painfully slow.
Next
From: Gavin Hamill
Date:
Subject: Re: pg 8.1.3, AIX, huge box, painfully slow.