| From: | "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com> |
|---|---|
| To: | fzied(at)planet(dot)tn, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Répondre |
| Date: | 2006-06-03 10:52:23 |
| Message-ID: | 20060603105223.GB25615@uio.no |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Sat, Jun 03, 2006 at 11:38:10AM +0100, fzied(at)planet(dot)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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Boreham | 2006-06-03 12:43:24 | Re: scaling up postgres |
| Previous Message | PFC | 2006-06-03 09:57:50 | Re: scaling up postgres |