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 4A8B59DCB53 for ; Thu, 16 Mar 2006 11:20: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 29717-01 for ; Thu, 16 Mar 2006 11:20:36 -0400 (AST) X-Greylist: delayed 02:09:13.06468 by SQLgrey- Received: from mail.aeccom.com (port-83-236-156-26.static.qsc.de [83.236.156.26]) by postgresql.org (Postfix) with ESMTP id 6B9729DCA75 for ; Thu, 16 Mar 2006 11:20:29 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by mail.aeccom.com (Postfix) with ESMTP id 21EF41C0D4; Thu, 16 Mar 2006 16:20:34 +0100 (CET) Received: from mail.aeccom.com ([127.0.0.1]) by localhost (gate6.aeccom.com [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 20943-02-5; Thu, 16 Mar 2006 16:20:33 +0100 (CET) Received: from [192.168.2.14] (andes.core.aeccom.com [192.168.2.14]) by mail.aeccom.com (Postfix) with ESMTP id 2F2471C0D0; Thu, 16 Mar 2006 16:20:33 +0100 (CET) Message-ID: <4419823F.6060205@aeccom.com> Date: Thu, 16 Mar 2006 16:20:31 +0100 From: Sven Geisler Organization: AEC/communications GmbH User-Agent: Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 To: Guillaume Smet CC: Richard Huxton , pgsql-performance@postgresql.org Subject: Re: PostgreSQL and Xeon MP References: <1d4e0c10603160245n55128e86t35431a339afcf8cc@mail.gmail.com> <44194A4B.3020106@archonet.com> <1d4e0c10603160428s1a3c1f4cocbe8489634524387@mail.gmail.com> <441963F4.1010607@aeccom.com> <1d4e0c10603160617w5d5aadc7o553103694fc3ca08@mail.gmail.com> In-Reply-To: <1d4e0c10603160617w5d5aadc7o553103694fc3ca08@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: amavisd-new at aeccom.com X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.144 required=5 tests=[AWL=0.144] X-Spam-Score: 0.144 X-Spam-Level: X-Archive-Number: 200603/240 X-Sequence-Number: 17677 Hi Guillaume, Guillaume Smet schrieb: > > 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 > .... > >> 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 > Did you compare 7.4 on a 4-way with 8.1 on a 2-way? How many queries and clients did you use to test the performance? How much faster is the XEON DP? I think, you can expect that your XEON DP is faster on a single query because CPU and RAM are faster. The overall performance can be better on your XEON DP if you only have a few clients. I guess, the newer hardware and the newer PostgreSQL version cause the better performance. Regards Sven.