On 7/11/07, Andrew Sullivan <ajs@crankycanuck.ca> wrote:
> On Tue, Jul 10, 2007 at 08:09:11PM +0200, Adrian von Bidder wrote:
>
> > If your operating system is able to schedule the threads/processes across
> > CPUs, PostgreSQL will use them.
>
> But notice that hyperthreading imposes its own overhead. I've not
> seen evidence that enabling hyperthreading actually helps, although I
> may have overlooked a couple of cases.
I don't have any metrics of my own to present (nor do I care enough
to try and gather them), but there are a few tests with kind of varied
results, depending on WHAT one wants to use HT for.
Have a look at these:
http://www.ibm.com/developerworks/linux/library/l-htl/
http://www.2cpu.com/articles/41_6.html
In how far they're relevant to Postgres is left as an
exercise to the reader :}
> A
Cheers,
Andrej
--
Please don't top post, and don't use HTML e-Mail :} Make your quotes concise.
http://www.american.edu/econ/notes/htmlmail.htm