From: Steinar H. Gunderson <sgunderson@bigfoot.com>
To: fzied@planet.tn
To: pgsql-performance@postgresql.org
Subject: Re: Répondre
Date: Sat, 3 Jun 2006 12:52:23 +0200
Message-ID: <20060603105223.GB25615@uio.no> (raw)
In-Reply-To: <200606031038.k53AcAR3014059@smtp2.planet.net.tn>
References: <200606031038.k53AcAR3014059@smtp2.planet.net.tn>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: sgunderson@bigfoot.com, fzied@planet.tn
Subject: Re: Répondre
In-Reply-To: <20060603105223.GB25615@uio.no>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox