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 7AE5F9DC854 for ; Thu, 16 Mar 2006 12:05:43 -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 38527-01 for ; Thu, 16 Mar 2006 12:05:40 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.192]) by postgresql.org (Postfix) with ESMTP id CDEE69DC849 for ; Thu, 16 Mar 2006 12:05:39 -0400 (AST) Received: by zproxy.gmail.com with SMTP id 8so364040nzo for ; Thu, 16 Mar 2006 08:05:39 -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=Sjq9ZxudZlDSftyAb2ToQULX2wMhDA2TNyrROb6snyCw4X56cAMqVr3zCrn2NcNgx0crmibV8jAZ/iXc4xHgNaeUlP940zlBSKh/u6HSSC9B5yxX9bZtR2pBnaWZ3gpLhG8IqQHjyurHzlvpq+0z6DqAxqiivcsWPP62lgsEv+A= Received: by 10.64.27.20 with SMTP id a20mr1216262qba; Thu, 16 Mar 2006 08:05:38 -0800 (PST) Received: by 10.65.123.12 with HTTP; Thu, 16 Mar 2006 08:05:38 -0800 (PST) Message-ID: <1d4e0c10603160805n6d727a94ic2ab0ed0bcf56c1a@mail.gmail.com> Date: Thu, 16 Mar 2006 17:05:38 +0100 From: "Guillaume Smet" To: "Sven Geisler" Subject: Re: PostgreSQL and Xeon MP Cc: pgsql-performance@postgresql.org In-Reply-To: <4419823F.6060205@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> <1d4e0c10603160617w5d5aadc7o553103694fc3ca08@mail.gmail.com> <4419823F.6060205@aeccom.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.188 required=5 tests=[AWL=0.188] X-Spam-Score: 0.188 X-Spam-Level: X-Archive-Number: 200603/242 X-Sequence-Number: 17679 On 3/16/06, Sven Geisler wrote: > Did you compare 7.4 on a 4-way with 8.1 on a 2-way? I know there are too many parameters changing between the two servers but I can't really change anything before tuesday. On tuesday, we will be able to compare both servers with the same software. > How many queries and clients did you use to test the performance? Googlebot is indexing this site generating 2-3 mbits/s of traffic so we use the googlebot to stress this server. There was a lot of clients and a lot of queries. > 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.