Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id BD9649FB47D for ; Mon, 9 Jul 2007 16:05:06 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 26604-07 for ; Mon, 9 Jul 2007 16:04:56 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.177]) by postgresql.org (Postfix) with ESMTP id 788999FB820 for ; Mon, 9 Jul 2007 16:04:58 -0300 (ADT) Received: by wa-out-1112.google.com with SMTP id k40so1614773wah for ; Mon, 09 Jul 2007 12:04:57 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=QYixuYhQvGiXJGMjRXbtaeX5Fv8PmVMkb/wCbpi47wBGHvh3VmzALp1hWJJho1JCyoIXKAazU46HgreHU3hlbwWJqmOHAwFI3NGq7bxc+A0bTX+SxB0PBjkbjmRQJJZzMnyMmhlXCBnilclAO+F2fA7ha8mxp+qOf3Wf7ZB9PEk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=NgCXD7zncIAqQKpRACyvlRUOEIn4FbS8KQn2bg7I6ZGXev5lCm7WE6bt4kJFso1RxEwRfApTe+/UPuacTC6oEGykv3cCgJZ9TfuiaK3B13xkvShQIH2yGhzJu4SCzFqmOwdLEK0ImNjQsukz/Hv0dXcwLKnsvI0bquhnyLQbY8k= Received: by 10.114.146.1 with SMTP id t1mr3414448wad.1184007893766; Mon, 09 Jul 2007 12:04:53 -0700 (PDT) Received: by 10.114.178.5 with HTTP; Mon, 9 Jul 2007 12:04:53 -0700 (PDT) Message-ID: <36e682920707091204j4f3e191dgf71da0cf6e9fed0@mail.gmail.com> Date: Mon, 9 Jul 2007 15:04:53 -0400 From: "Jonah H. Harris" To: "Greg Smith" Subject: Re: PostgreSQL publishes first real benchmark Cc: pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <46925AD9.9020208@sun.com> <36e682920707090921u433f9702n907e3a8d562a61ac@mail.gmail.com> <46926208.1070003@commandprompt.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/65 X-Sequence-Number: 25749 On 7/9/07, Greg Smith wrote: > There's just enough hardware differences between the two configurations > that it's not quite a fair fight. For example, the MySQL test had 10K RPM > drives in the database server storage array, while the PostgreSQL one had > 15K RPM ones. A few other small differences as well if you dig into the > configurations, all of which I noted favored the PG system. Agreed. -- Jonah H. Harris, Software Architect | phone: 732.331.1324 EnterpriseDB Corporation | fax: 732.331.1301 33 Wood Ave S, 3rd Floor | jharris@enterprisedb.com Iselin, New Jersey 08830 | http://www.enterprisedb.com/