Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id CA9379FB528 for ; Fri, 23 Feb 2007 15:34:50 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 33036-08 for ; Fri, 23 Feb 2007 15:34:43 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.173]) by postgresql.org (Postfix) with ESMTP id ADF959FC2D3 for ; Fri, 23 Feb 2007 15:34:42 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so400359ugf for ; Fri, 23 Feb 2007 11:34:41 -0800 (PST) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=YA/Vw4Q6Kh1kDnYxpPXR2nohafxIOPt87KSEZlYLt89MYdplkaKW+GBtLFkFX6fUTaks35pwGd4IWS1qgQrBClOPm3MygcDzyoVSCp9/x70T4Ylcn9TJve7VXVZuFaVZVy6CtiSd086Bo7kV/G6r0PHjdQOAxn7aYzp2XaBACz8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=SgUjci79h4wUJ2DBTbQNuvitn5zpDnWettpw3MGUkJyN/fOAzsyLPHcAlZcoZEEz0OTXgYbAqbxH0zrdBXeBFytG0HMBPMEbb/E/gOs+uUGQ5Y9TgxWfSEXzSePOZy3cAaGM7nc2BMtw20SIxA6KzEq9jFh/clKebxMmXsZKAf4= Received: by 10.78.171.20 with SMTP id t20mr215538hue.1172259221244; Fri, 23 Feb 2007 11:33:41 -0800 (PST) Received: by 10.78.100.9 with HTTP; Fri, 23 Feb 2007 11:33:41 -0800 (PST) Message-ID: Date: Fri, 23 Feb 2007 20:33:41 +0100 From: "Claus Guttesen" To: Geoffrey Subject: Re: which Xeon processors don't have the context switching problem Cc: pgsql-performance@postgresql.org In-Reply-To: <45DF3B15.1070609@3times25.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <45DF3B15.1070609@3times25.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/254 X-Sequence-Number: 23308 > I recall a reference on the list indicating that newer Xeon processors > don't suffer from the context switching problem reported last year. > > In searching the archives, I can't find any specific info indentifying > which Xeon processors don't have this problem. > > Anyone point me to a reference? We recently migrated to a woodcrest @ 3 GHz from a 2 Ghz opteron. The woodcrest seems to be enjoying doing db-related work. I don't have numbers other than load is much lower now. > Is this in any way related to the version of Postgresql one is running? > We're headed for 8, but have a bit of work before we can get there. > We are currently on 7.4.16. We are at 7.4.14 which works fine atm. regards Claus