Re: 100 times faster than mysql

From: Allan Kamau <kamauallan(at)gmail(dot)com>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: 100 times faster than mysql
Date: 2011-07-26 14:02:12
Message-ID: CAF3N6oRXzXf0+eBaUWE-AUzO+R2U3UZV9qGSoD3UnrXOPifSkg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jul 26, 2011 at 4:41 PM, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
> http://codesynthesis.com/~boris/blog/2011/07/26/odb-1-5-0-released/
>
> merlin
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

"The surprising part is that PostgreSQL 9.0.4 is more than 100 times
faster on this test than MySQL 5.1.49 with the InnoDB backend (186s
for MySQL, 48s for SQLite, and 12s for PostgreSQL). Postgre developers
seem to be doing something right."

If the speed is to be measured purely (and simply) on these numbers,
186/12 yields 15.5 (or maybe 16 if your round it up or 15 if you use
integer division). May be about 15~16 times faster would be more in
line with numbers provided.

Allan.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mcleod, John 2011-07-26 14:03:18 Re: pgsql error
Previous Message Merlin Moncure 2011-07-26 13:41:24 100 times faster than mysql