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 307DE9DC854 for ; Thu, 16 Mar 2006 12:37:01 -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 45343-01 for ; Thu, 16 Mar 2006 12:36:58 -0400 (AST) X-Greylist: from auto-whitelisted 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 7224F9DCA44 for ; Thu, 16 Mar 2006 12:36:57 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by mail.aeccom.com (Postfix) with ESMTP id 0BC731C1CA; Thu, 16 Mar 2006 17:36:55 +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 21532-02-5; Thu, 16 Mar 2006 17:36:54 +0100 (CET) Received: from [192.168.2.14] (andes.core.aeccom.com [192.168.2.14]) by mail.aeccom.com (Postfix) with ESMTP id 384E41C118; Thu, 16 Mar 2006 17:36:54 +0100 (CET) Message-ID: <44199424.1080107@aeccom.com> Date: Thu, 16 Mar 2006 17:36:52 +0100 From: Sven Geisler Organization: AEC/communications GmbH User-Agent: Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 To: Guillaume Smet CC: 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> <4419823F.6060205@aeccom.com> <1d4e0c10603160805n6d727a94ic2ab0ed0bcf56c1a@mail.gmail.com> In-Reply-To: <1d4e0c10603160805n6d727a94ic2ab0ed0bcf56c1a@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.137 required=5 tests=[AWL=0.137] X-Spam-Score: 0.137 X-Spam-Level: X-Archive-Number: 200603/245 X-Sequence-Number: 17682 Hi Guillaume, Guillaume Smet schrieb: >> How much faster is the XEON DP? > > Well, on high load, PostgreSQL scales well on the DP (load at 40, > queries slower but still performing well) and is awfully slow on the > MP box. I know what you mean with awfully slow. I think, your application is facing contention. The contention becomes larger as more CPU you have. PostgreSQL 8.1 is addressing contention on multiprocessor servers as you mentioned before. I guess, you will see that your 4-way XEON MP isn't that bad if you compare both servers with the same PostgreSQL version. Regards Sven.