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 A5D6D5E3639 for ; Thu, 19 Aug 2004 02:49:25 -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 93846-04 for ; Thu, 19 Aug 2004 05:49:16 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id D9BEC5E37CE for ; Thu, 19 Aug 2004 02:49:15 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i7J5nFeB012078; Thu, 19 Aug 2004 01:49:15 -0400 (EDT) To: William Yu Cc: pgsql-performance@postgresql.org Subject: Re: Help specifying new machine In-reply-to: References: <20040809165657.GB15169@campbell-lange.net> Comments: In-reply-to William Yu message dated "Wed, 18 Aug 2004 21:26:45 -0700" Date: Thu, 19 Aug 2004 01:49:15 -0400 Message-ID: <12077.1092894555@sss.pgh.pa.us> From: Tom Lane 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/285 X-Sequence-Number: 7921 William Yu writes: > In terms of Postgres database performance, Opteron *may* be the better > CPU for this app but there's not enough data points yet. Here's a recent > review at Anandtech showing Opteron 150 (2.4ghz) versus 64-bit Prescott > 3.6hgz with some very simple MySQL and Postgres benchmarks: > http://www.anandtech.com/linux/showdoc.aspx?i=2163&p=2 > What is a slight lead in MySQL becomes a blowout in Postgres. 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. regards, tom lane