From: Matt Clark <matt@ymogen.net>
To: Josh Close <narshe@gmail.com>
Cc: POSTGRES-PERFORMANCE <pgsql-performance@postgresql.org>
Subject: Re: how much mem to give postgres?
Date: Wed, 20 Oct 2004 15:07:00 +0100
Message-ID: <41767104.10702@ymogen.net> (raw)
In-Reply-To: <4a0cafe204102006391f726a4f@mail.gmail.com>
References: <4a0cafe2041019153133f854e9@mail.gmail.com>
<200410192223.24285.josh@agliodbs.com>
<4a0cafe204102006391f726a4f@mail.gmail.com>
>How would I turn that off? In the kernel config? Not too familiar with
>that. I have a 2 proc xeon with 4 gigs of mem on the way for postgres,
>so I hope HT isn't a problem. If HT is turned off, does it just not
>use the other "half" of the processor? Or does the processor just work
>as one unit?
>
>
You turn it off in the BIOS. There is no 'other half', the processor is
just pretending to have two cores by shuffling registers around, which
gives maybe a 5-10% performance gain in certain multithreaded
situations. <opinion>A hack to overcome marchitactural limitations due
to the overly long pipeline in the Prescott core.</opinion>. Really of
most use for desktop interactivity rather than actual throughput.
M
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: matt@ymogen.net, narshe@gmail.com
Subject: Re: how much mem to give postgres?
In-Reply-To: <41767104.10702@ymogen.net>
* 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