X-Original-To: pgsql-hackers-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 6288B9FA6A2 for ; Tue, 11 Jul 2006 11:25:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 63493-01 for ; Tue, 11 Jul 2006 11:25:13 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from outmail128144.authsmtp.com (outmail128144.authsmtp.com [62.13.128.144]) by postgresql.org (Postfix) with ESMTP id 396579FAC9B for ; Tue, 11 Jul 2006 11:25:10 -0300 (ADT) Received: from [10.2.227.252] ([216.123.178.194]) (authenticated bits=0) by squirrel.dmpriest.net.uk (8.13.6/8.13.6/Kp) with ESMTP id k6BEOsGt044743; Tue, 11 Jul 2006 15:24:55 +0100 (BST) Message-ID: <44B3B4BF.7050907@agliodbs.com> Date: Tue, 11 Jul 2006 10:25:03 -0400 From: Josh Berkus User-Agent: Mozilla Thunderbird 1.0.6 (Macintosh/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Katsuhiko Okano CC: pgsql-hackers@postgresql.org Subject: Re: poor performance with Context Switch Storm at TPC-W. References: <200607112009.FED09315.TLPPUBIBOPuVLJL@oss.ntt.co.jp> In-Reply-To: <200607112009.FED09315.TLPPUBIBOPuVLJL@oss.ntt.co.jp> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Server-Quench: 068364ec-10e9-11db-b770-001185d377ca X-AuthRoute: OCdyZgscClZXSx8a IioLCC5HRQ8+YBZL BAkGMA9GIUINWEQL c1ADdx1xLVlbHwkB BXYKXl5WVFd0Xy13 agxPbAdefEtJVxtr WUxWQFdQERpoT0cH dGthEW42dwFCf3pz K0FnWz5bWkx5c0Io EVNVFTgPeGZhPDIC Akdfdx5UcAJLdhoR aVd4ByJDAzANdhEY NiQQEgoKCH1HLyNP ChkAN1wVW0MCGDUx Dw8DATVnNkoDWygj M1QdNV8AF0ZZCVk1 K15pUE5QDyc5TzIY d1VF X-Authentic-SMTP: 61633136333939.squirrel.dmpriest.net.uk:1.56/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system! X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/195 X-Sequence-Number: 86050 Katsuhiko, Have you tried turning HT off? HT is not generally considered (even by Intel) a good idea for database appplications. --Josh