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/