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 EBA313A5086 for ; Sat, 8 Jan 2005 02:57:50 +0000 (GMT) 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 37061-02 for ; Sat, 8 Jan 2005 02:57:40 +0000 (GMT) Received: from mail.tecarta.com (66.238.115.135.ptr.us.xo.net [66.238.115.135]) by svr1.postgresql.org (Postfix) with ESMTP id 2649D3A505E for ; Sat, 8 Jan 2005 02:57:21 +0000 (GMT) Received: from mail pickup service by mail.tecarta.com with Microsoft SMTPSVC; Fri, 7 Jan 2005 18:59:39 -0800 Received: from mail.tecarta.com ([192.168.160.2]) by mail.tecarta.com with Microsoft SMTPSVC(6.0.3790.0); Fri, 7 Jan 2005 18:59:34 -0800 Received: from barracuda.tecarta.com ([192.168.160.200]) by mail.tecarta.com (SAVSMTP 3.1.0.29) with SMTP id M2005010718593419683 for ; Fri, 07 Jan 2005 18:59:34 -0800 X-ASG-Debug-ID: 1105153025-2584-0-0 X-Barracuda-URL: http://192.168.160.200:8000/cgi-bin/mark.cgi Received: from mail1 (mail1.hq.corp [192.168.160.5]) by barracuda.tecarta.com (Spam Firewall) with SMTP id 5A820200D547 for ; Fri, 7 Jan 2005 18:57:05 -0800 (PST) Received: from [192.168.0.13] ([63.206.203.145]) by mail.tecarta.com with Microsoft SMTPSVC(6.0.3790.0); Fri, 7 Jan 2005 18:59:28 -0800 Message-ID: <41DED994.9070305@sfnet.cc> Date: Fri, 07 Jan 2005 18:48:52 +0000 From: Steve Poe User-Agent: Mozilla Thunderbird 1.0 (X11/20041228) X-Accept-Language: en-us, en MIME-Version: 1.0 To: josh@agliodbs.com Cc: PGsql-performance X-ASG-Orig-Subj: Re: [PERFORM] Does "HYPERTHREADING" do any harm if we use with RH9.0 and postgresql? Subject: Re: Does "HYPERTHREADING" do any harm if we use with RH9.0 References: <1105144158.41df295e07cc9@webmail.moph.go.th> <200501071720.08858.josh@agliodbs.com> In-Reply-To: <200501071720.08858.josh@agliodbs.com> Content-Type: text/plain; charset=TIS-620; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 08 Jan 2005 02:59:28.0287 (UTC) FILETIME=[116CF2F0:01C4F52E] X-Virus-Scanned: by Barracuda Spam Firewall at tecarta.com X-Barracuda-Spam-Score: -4.55 X-Barracuda-Spam-Status: No, SCORE=-4.55 using global scores of TAG_LEVEL=4.0 QUARANTINE_LEVEL=1000.0 KILL_LEVEL=7.0 tests=BAYES_00, DATE_IN_PAST_06_12 X-Barracuda-Spam-Report: Code version 2.64, rules version 2.1.792 Rule breakdown below pts rule name description ---- ---------------------- ------------------------------------------- -5.40 BAYES_00 BODY: Bayesian spam probability is 0 to 1% [score: 0.0052] 0.85 DATE_IN_PAST_06_12 Date: is 6 to 12 hours before Received: date X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.336 tagged_above=0 required=5 tests=AWL, DATE_IN_PAST_06_12, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200501/85 X-Sequence-Number: 9775 Josh Berkus wrote: >Amrit, > > > >>I use RH 9.0 with postgresql 7.3.2 and 4 Gb ram [server spec. Dual Xeon >>3.0] and someone mention that the hyperthreading will not help but if I let >>it there will it be any harm to the system? >>Any comment please. >> >> > >Sometimes. Run a test and take a look at your CS (context switch) levels on >VMSTAT. If they're high, turn HT off. > >If it's a dedicated PG system, though, just turn HT off. We can't use it. > >Also, upgrade PostgreSQL to 7.3.8 at least. 7.3.2 is known-buggy. > > > Sorry for the "dumb" question, but what would be considered high regarding CS levels? We just upgraded our server's to dual 2.8Ghz Xeon CPUs from dual Xeon 1.8Ghz which unfortunately HT built-in. We also upgraded our database from version 7.3.4 to 7.4.2 Thanks. Steve Poe