X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2EDBB329F1E for ; Wed, 20 Oct 2004 18:44:24 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 36063-03 for ; Wed, 20 Oct 2004 17:44:14 +0000 (GMT) Received: from gp.word-to-the-wise.com (gp.word-to-the-wise.com [64.71.176.18]) by svr1.postgresql.org (Postfix) with ESMTP id B12F2329F0C for ; Wed, 20 Oct 2004 18:44:13 +0100 (BST) Received: by gp.word-to-the-wise.com (Postfix, from userid 500) id 0EB529029FB; Wed, 20 Oct 2004 10:50:39 -0700 (PDT) Date: Wed, 20 Oct 2004 10:50:39 -0700 From: Steve Atkins To: POSTGRES-PERFORMANCE Subject: Re: how much mem to give postgres? Message-ID: <20041020175038.GA1339@gp.word-to-the-wise.com> References: <4a0cafe2041019153133f854e9@mail.gmail.com> <200410192223.24285.josh@agliodbs.com> <4a0cafe204102006391f726a4f@mail.gmail.com> <41767104.10702@ymogen.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <41767104.10702@ymogen.net> User-Agent: Mutt/1.4.1i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/327 X-Sequence-Number: 8803 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. > A hack to overcome marchitactural limitations due > to the overly long pipeline in the Prescott core.. Really of > most use for desktop interactivity rather than actual throughput. 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. 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