X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id BBE6F9FB33A for ; Mon, 31 Jul 2006 13:05:42 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 00728-10 for ; Mon, 31 Jul 2006 13:05:24 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.198]) by postgresql.org (Postfix) with ESMTP id 094C99FB336 for ; Mon, 31 Jul 2006 13:04:37 -0300 (ADT) Received: by nz-out-0102.google.com with SMTP id i11so222808nzi for ; Mon, 31 Jul 2006 09:04:26 -0700 (PDT) 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=DcqiSIweFH9faAjjfH3NWzuah/0351ZFu/vZBMrYjvk7p+Cqp+HV7Y9g4z6XSWhURVUAKKRk9eAnNI77JDXNDU8R+LyVLls7b+YmQDjW+ZccTjnR4TyFAfsi0JMWjLaKxkHTFUu/358bP/WN5A4L3keqo6BvjBPxiXSYmrCnbRY= Received: by 10.65.139.9 with SMTP id r9mr4105016qbn; Mon, 31 Jul 2006 09:04:26 -0700 (PDT) Received: by 10.65.139.10 with HTTP; Mon, 31 Jul 2006 09:04:26 -0700 (PDT) Message-ID: Date: Mon, 31 Jul 2006 12:04:26 -0400 From: "Merlin Moncure" To: "Jochem van Dieten" Subject: Re: PostgreSQL scalability on Sun UltraSparc T1 Cc: pgsql-performance@postgresql.org In-Reply-To: <44CB7896.8030501@oli.tudelft.nl> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <44CB7896.8030501@oli.tudelft.nl> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.467 tagged_above=0 required=5 tests=AWL, SPF_HELO_SOFTFAIL, SPF_SOFTFAIL X-Spam-Level: ** X-Archive-Number: 200607/316 X-Sequence-Number: 20176 On 7/29/06, Jochem van Dieten wrote: > Tweakers.net has done a database performance test between a Sun T2000 (8 > core T1) and a Sun X4200 (2 dual core Opteron 280). The database > benchmark is developed inhouse and represents the average query pattern > from their website. It is MySQL centric because Tweakers.net runs on > MySQL, but Arjen van der Meijden has ported it to PostgreSQL and has > done basic optimizations like adding indexes. anandtech did a comparison of opteron/xeon/sun t1 not to long ago and published some mysql/postgresql results. however, they were careful not to publish the quad core data for pg to compare vs. mysql, which in my opinion would have shown a blowout victory for pg. (also was pg 8.0). the fact is, postgresql is often faster than mysql under real workloads, especially when utilizing features such as stored procedures and such. merlin