X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B273E5E40AC for ; Thu, 19 Aug 2004 13:20:03 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 94005-01 for ; Thu, 19 Aug 2004 16:20:02 +0000 (GMT) Received: from davinci.ethosmedia.com (server226.ethosmedia.com [209.128.84.226]) by svr1.postgresql.org (Postfix) with ESMTP id 02E105E46C0 for ; Thu, 19 Aug 2004 13:19:53 -0300 (ADT) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.1.8) with ESMTP id 6120743; Thu, 19 Aug 2004 09:21:16 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: Tom Lane , William Yu Subject: Re: Help specifying new machine Date: Thu, 19 Aug 2004 09:18:31 -0700 User-Agent: KMail/1.4.3 Cc: pgsql-performance@postgresql.org References: <20040809165657.GB15169@campbell-lange.net> <12077.1092894555@sss.pgh.pa.us> In-Reply-To: <12077.1092894555@sss.pgh.pa.us> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200408190918.31797.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/292 X-Sequence-Number: 7928 Tom, > This is really interesting. We had previously seen some evidence that > the Xeon sucks at running Postgres, but I thought that the issues only > materialized with multiple CPUs (because what we were concerned about > was the cost of transferring cache lines across CPUs). AFAICS this test > is using single CPUs. Maybe there is more going on than we realized. Aside from the fact that the Xeon architecture is a kludge? Intel really screwed up the whole Xeon line through some bad architectural decisions, and instead of starting over from scratch, "patched" the problem. The result has been sub-optimal Xeon performance for the last two years. This is why AMD is still alive. Better efficiency, lower cost. -- Josh Berkus Aglio Database Solutions San Francisco