X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id DD4A4D1CCA8 for ; Wed, 21 Apr 2004 05:31:47 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 45864-06 for ; Wed, 21 Apr 2004 05:31:48 -0300 (ADT) Received: from obie.mrkdns.com (obie.mrkdns.com [69.93.72.82]) by svr1.postgresql.org (Postfix) with ESMTP id 1B463D1BB36 for ; Wed, 21 Apr 2004 05:31:46 -0300 (ADT) Received: from [213.152.63.90] (helo=chuckie.co.uk) by obie.mrkdns.com with asmtp (Exim 4.30) id 1BGD92-0003PT-Rg for pgsql-performance@postgresql.org; Wed, 21 Apr 2004 09:31:48 +0100 Message-ID: <4086316B.4050304@chuckie.co.uk> Date: Wed, 21 Apr 2004 09:31:39 +0100 From: Nick Barr User-Agent: Mozilla Thunderbird 0.5 (Windows/20040207) X-Accept-Language: en-us, en MIME-Version: 1.0 To: PgSQL Performance ML Subject: MySQL vs PG TPC-H benchmarks Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - obie.mrkdns.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [0 0] / [47 12] X-AntiAbuse: Sender Address Domain - chuckie.co.uk X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200404/335 X-Sequence-Number: 6635 Hi, Has anyone had a look at: http://people.ac.upc.es/zgomez/ I realize that MySQL & PG cannot really be compared (especially when you consider the issues that MySQL has with things like data integrity) but still surely PG would perform better than the stats show (i.e. #7 31.28 seconds versus 42 minutes!!!). On a side note it certainly looks like linux kernel 2.6 is quite a bit faster in comparision to 2.4. Nick