Обсуждение: Re: Répondre

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/