Re: 100 times faster than mysql - Mailing list pgsql-general

From Allan Kamau
Subject Re: 100 times faster than mysql
Date
Msg-id CAF3N6oRXzXf0+eBaUWE-AUzO+R2U3UZV9qGSoD3UnrXOPifSkg@mail.gmail.com
Whole thread Raw
In response to 100 times faster than mysql  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: 100 times faster than mysql  (Radosław Smogura <rsmogura@softperience.eu>)
Re: 100 times faster than mysql  (Greg Smith <greg@2ndQuadrant.com>)
List pgsql-general
On Tue, Jul 26, 2011 at 4:41 PM, Merlin Moncure <mmoncure@gmail.com> wrote:
> http://codesynthesis.com/~boris/blog/2011/07/26/odb-1-5-0-released/
>
> merlin
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.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.

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: 100 times faster than mysql
Next
From: Tom Lane
Date:
Subject: Re: pgsql error