X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 99159D855B
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Sun, 20 Nov 2005 21:24:31 -0400 (AST)
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 89289-03
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Mon, 21 Nov 2005 01:24:31 +0000 (GMT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from net2.micro-automation.com (net2.micro-automation.com
	[64.7.141.29])
	by svr1.postgresql.org (Postfix) with SMTP id 7C431D6E94
	for <pgsql-performance@postgresql.org>;
	Sun, 20 Nov 2005 21:24:25 -0400 (AST)
Received: (qmail 1699 invoked from network); 21 Nov 2005 01:24:26 -0000
Received: from dcdsl.ebox.com (HELO ?192.168.1.2?) (davec@64.7.143.116)
	by net2.micro-automation.com with SMTP; 21 Nov 2005 01:24:26 -0000
In-Reply-To: <4380EEA2.4010002@modgraph-usa.com>
References: <BF9F6C0E.13B4A%llonergan@greenplum.com>
	<1132136225.5711.4.camel@Panoramix>
	<437B9DA9.2030806@modgraph-usa.com>
	<20051117002344.GA55377@winnie.fuhr.org>
	<437CF055.6020602@modgraph-usa.com>
	<20051117232857.GA49910@winnie.fuhr.org>
	<437D3085.9040207@modgraph-usa.com>
	<20051118034631.GA70159@winnie.fuhr.org>
	<437F66CF.7080402@modgraph-usa.com>
	<20051119190304.GJ7330@mathom.us>
	<4380EEA2.4010002@modgraph-usa.com>
Mime-Version: 1.0 (Apple Message framework v746.2)
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
Message-Id: <C875A76F-AC09-4207-97D6-DE7969244146@fastcrypt.com>
Cc: pgsql-performance@postgresql.org
Content-Transfer-Encoding: 7bit
From: Dave Cramer <pg@fastcrypt.com>
Subject: Re: Hyperthreading slows processes?
Date: Sun, 20 Nov 2005 20:24:24 -0500
To: Craig A. James <cjames@modgraph-usa.com>
X-Mailer: Apple Mail (2.746.2)
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.014 required=5 tests=[AWL=0.014]
X-Spam-Score: 0.014
X-Spam-Level: 
X-Archive-Number: 200511/416
X-Sequence-Number: 15673

Yeah, it's pretty much a known issue for postgres

Dave
On 20-Nov-05, at 4:46 PM, Craig A. James wrote:

> This article on ZDNet claims that hyperthreading can *hurt*  
> performance, due to contention in the L1/L2 cache by a second process:
>
>   http://news.zdnet.co.uk/0,39020330,39237341,00.htm
>
> Has anyone tested this on Postgres yet?  (And based on a recent  
> somewhat caustic thread about performance on this forum, I'm going  
> to avoid speculation, and let those who actually *know* answer! ;-)
>
> Craig
>
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>               http://archives.postgresql.org
>