Message-ID: <4436CE0D.6010702@i-logic.hu>
Date: Fri, 07 Apr 2006 22:39:41 +0200
From: =?ISO-8859-1?Q?G=E1briel_=C1kos?= <akos.gabriel@i-logic.hu>
Organization: I-Logic Kft
User-Agent: Thunderbird 1.5 (Windows/20051201)
MIME-Version: 1.0
To: Gavin Hamill <gdh@laterooms.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: pg 8.1.3, AIX, huge box, painfully slow.
References: <20060407185823.abe93017.gdh@laterooms.com>
In-Reply-To: <20060407185823.abe93017.gdh@laterooms.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

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            =-