From: Steve Atkins <steve@blighty.com>
To: POSTGRES-PERFORMANCE <pgsql-performance@postgresql.org>
Subject: Re: how much mem to give postgres?
Date: Wed, 20 Oct 2004 10:50:39 -0700
Message-ID: <20041020175038.GA1339@gp.word-to-the-wise.com> (raw)
In-Reply-To: <41767104.10702@ymogen.net>
References: <4a0cafe2041019153133f854e9@mail.gmail.com>
<200410192223.24285.josh@agliodbs.com>
<4a0cafe204102006391f726a4f@mail.gmail.com>
<41767104.10702@ymogen.net>
On Wed, Oct 20, 2004 at 03:07:00PM +0100, Matt Clark wrote:
> 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.
<OT>
Hyperthreading is actually an excellent architectural feature that
can give significant performance gains when implemented well and used
for an appropriate workload under a decently HT aware OS.
IMO, typical RDBMS streams are not an obviously appropriate workload,
Intel didn't implement it particularly well and I don't think there
are any OSes that support it particularly well.
</OT>
But don't write off using it in the future, when it's been improved
at both the OS and the silicon levels.
Cheers,
Steve
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: steve@blighty.com
Subject: Re: how much mem to give postgres?
In-Reply-To: <20041020175038.GA1339@gp.word-to-the-wise.com>
* 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