Re: Répondre - Mailing list pgsql-performance

From Steinar H. Gunderson
Subject Re: Répondre
Date
Msg-id 20060603105223.GB25615@uio.no
Whole thread Raw
List pgsql-performance
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/

pgsql-performance by date:

Previous
From: PFC
Date:
Subject: Re: scaling up postgres
Next
From: David Boreham
Date:
Subject: Re: scaling up postgres