Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 9AA122E0099 for ; Fri, 25 Apr 2008 21:37:55 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 59602-06-5 for ; Fri, 25 Apr 2008 21:37:38 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from host.newx.com.br (host.newx.com.br [216.40.252.42]) by developer.postgresql.org (Postfix) with ESMTP id 845652E009B for ; Fri, 25 Apr 2008 21:37:31 -0300 (ADT) Received: from [201.21.251.217] (helo=[10.1.2.10]) by host.newx.com.br with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.68) (envelope-from ) id 1JpYPt-0006qN-Mm; Fri, 25 Apr 2008 21:37:25 -0300 Message-ID: <481278E7.9030504@timbira.com> Date: Fri, 25 Apr 2008 21:35:51 -0300 From: Euler Taveira de Oliveira User-Agent: Thunderbird 2.0.0.12 (X11/20080302) MIME-Version: 1.0 To: Greg Smith CC: pgsql-advocacy@postgresql.org Subject: Re: Sun Talks about MySQL References: <480F8C2D.6010806@emproshunts.com> <4811D1DD.9030401@otg-nc.com> <20080425130105.GA19447@crankycanuck.ca> <36e682920804250741p33d621f3gf35e6bdebe2e0531@mail.gmail.com> <20080425152053.GE19447@crankycanuck.ca> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; 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 - host.newx.com.br X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - timbira.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/141 X-Sequence-Number: 13867 Greg Smith wrote: > An interesting data point is they advertise a 10-15% gain in DBT2 > results. I've started thinking about a 2008 update to my "PostgreSQL vs. > MySQL" paper that covers PG 8.3 and MySQL 5.1. I'd love to have a > similar comparision using that same benchmark of PG8.2->PG8.3. I recall > Heikki was doing lots of tests with DBT2 for EnterpriseDB comparing > those two releases like that; anybody know of a good summary I could > utilize there? I thought that was one of the benchmarks that got a > 20-30% speedup on going to 8.3 because it really took advantage of HOT > in particular. > I did some benchmarks for 8.2 and 8.3. I'll show them at PGCon in a few weeks. But I didn't try MySQL. It would be good if someone should do such a comparison. -- Euler Taveira de Oliveira http://www.timbira.com/