X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 488DF9DC9E7 for ; Thu, 16 Mar 2006 10:17:32 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 17374-09 for ; Thu, 16 Mar 2006 10:17:35 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.198]) by postgresql.org (Postfix) with ESMTP id B9E099DC9E6 for ; Thu, 16 Mar 2006 10:17:29 -0400 (AST) Received: by zproxy.gmail.com with SMTP id 8so342606nzo for ; Thu, 16 Mar 2006 06:17:34 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=c5FqWMjm1mnL4yHnxVpY5UNo1Pvo9sWltCQVmgRg4JO8vOvpeJNTr/9gT5bb1Fx6pXt0BnsNvyz0+VkAdpdhZnqnvwdb1Ftd1yTTFipzDUP5lhMRHG7beBDZ14CsClTx3WzIg++Tx4r2kjAgSBundIdn6IuMAou9qgfE/haj4NI= Received: by 10.65.151.6 with SMTP id d6mr416991qbo; Thu, 16 Mar 2006 06:17:32 -0800 (PST) Received: by 10.65.123.12 with HTTP; Thu, 16 Mar 2006 06:17:32 -0800 (PST) Message-ID: <1d4e0c10603160617w5d5aadc7o553103694fc3ca08@mail.gmail.com> Date: Thu, 16 Mar 2006 15:17:32 +0100 From: "Guillaume Smet" To: "Sven Geisler" Subject: Re: PostgreSQL and Xeon MP Cc: "Richard Huxton" , pgsql-performance@postgresql.org In-Reply-To: <441963F4.1010607@aeccom.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <1d4e0c10603160245n55128e86t35431a339afcf8cc@mail.gmail.com> <44194A4B.3020106@archonet.com> <1d4e0c10603160428s1a3c1f4cocbe8489634524387@mail.gmail.com> <441963F4.1010607@aeccom.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.211 required=5 tests=[AWL=0.211] X-Spam-Score: 0.211 X-Spam-Level: X-Archive-Number: 200603/237 X-Sequence-Number: 17674 Sven, On 3/16/06, Sven Geisler wrote: > What version of XEON MP does your server have? The server is a dell 6650 from end of 2004 with 4 xeon mp 2.2 and 2MB cache per proc. Here are the information from Dell: 4x PROCESSOR, 80532, 2.2GHZ, 2MB cache, 400Mhz, SOCKET F 8x DUAL IN-LINE MEMORY MODULE, 512MB, 266MHz > Do you use Hyperthreading? No, we don't use it. > You should provide details from the XEON DP? The only problem is that the Xeon DP is installed with a 2.6 kernel and a postgresql 8.1.3 (it is used to test the migration from 7.4 to 8.1.3). So it's very difficult to really compare the two behaviours. It's a Dell 2850 with: 2 x PROCESSOR, 80546K, 2.8G, 1MB cache, XEON NOCONA, 800MHz 4 x DUAL IN-LINE MEMORY MODULE, 1GB, 400MHz This server is obviously newer than the other one. -- Guillaume