Date: Sat, 3 Jun 2006 12:52:23 +0200
From: "Steinar H. Gunderson" <sgunderson@bigfoot.com>
To: fzied@planet.tn, pgsql-performance@postgresql.org
Subject: Re: =?utf-8?B?UsOpcG9uZHJl?=
Message-ID: <20060603105223.GB25615@uio.no>
Reply-To: pgsql-performance@postgresql.org
Mail-Followup-To: fzied@planet.tn, pgsql-performance@postgresql.org
References: <200606031038.k53AcAR3014059@smtp2.planet.net.tn>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: <200606031038.k53AcAR3014059@smtp2.planet.net.tn>
User-Agent: Mutt/1.5.11+cvs20060403

On Sat, Jun 03, 2006 at 11:38:10AM +0100, fzied@planet.tn wrote:
>> What version of PostgreSQL? (8.1 is better than 8.0 is much better than 7.4.)
> 8.1.3 on RHEL 4

OK, that sounds good.

>> Have you remembered to turn HT off?
> no !! what is it ?

HT = Hyperthreading. It usually does more harm than good on databases
(although others have reported differing results).

>>  Have you considered Opterons instead of Xeons? (The Xeons generally
>> scale bad with PostgreSQL.) 
> No can't have it

OK, that's bad -- it's probably the single thing that could have helped
performance the most.

/* Steinar */
-- 
Homepage: http://www.sesse.net/