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 3F607DB081 for ; Tue, 22 Nov 2005 13:15:00 -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 79451-03 for ; Tue, 22 Nov 2005 17:14:58 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from yertle.kcilink.com (yertle.kcilink.com [65.205.34.180]) by svr1.postgresql.org (Postfix) with ESMTP id B6303DB080 for ; Tue, 22 Nov 2005 13:14:56 -0400 (AST) Received: from [192.168.7.103] (host-103.int.kcilink.com [192.168.7.103]) by yertle.kcilink.com (Postfix) with ESMTP id D67FAB80D for ; Tue, 22 Nov 2005 12:14:55 -0500 (EST) Mime-Version: 1.0 (Apple Message framework v746.2) In-Reply-To: <4BAFBB6B9CC46F41B2AD7D9F4BBAF785098E73@vt-pe2550-001.vantage.vantage.com> References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF785098E73@vt-pe2550-001.vantage.vantage.com> Content-Type: multipart/alternative; boundary=Apple-Mail-2--246327675 Message-Id: <0D46FCC7-9DB2-4B45-B7C3-4F76EF53DB1F@khera.org> From: Vivek Khera Subject: Re: High context switches occurring Date: Tue, 22 Nov 2005 12:14:54 -0500 To: Postgresql Performance X-Mailer: Apple Mail (2.746.2) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.129 required=5 tests=[AWL=-0.128, HTML_FONT_BIG=0.256, HTML_MESSAGE=0.001] X-Spam-Score: 0.129 X-Spam-Level: X-Archive-Number: 200511/446 X-Sequence-Number: 15703 --Apple-Mail-2--246327675 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed On Nov 22, 2005, at 11:59 AM, Anjan Dave wrote: > This is a Dell Quad XEON. Hyperthreading is turned on, and I am > planning to turn it off as soon as I get a chance to bring it down. > You should probably also upgrade to Pg 8.0 or newer since it is a known problem with XEON processors and older postgres versions. Upgrading Pg may solve your problem or it may not. It is just a fluke with XEON processors... --Apple-Mail-2--246327675 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=ISO-8859-1
On Nov 22, 2005, = at 11:59 AM, Anjan Dave wrote:=A0

This is a Dell Quad XEON. Hyperthreading is = turned on, and I am planning to turn it off as soon as I get a chance to = bring it down.


You = should probably also upgrade to Pg 8.0 or newer since it is a known = problem with XEON processors and older postgres versions.=A0 Upgrading = Pg may solve your problem or it may not.=A0 It is just a fluke with XEON = processors...


= --Apple-Mail-2--246327675--