Re: postgresql vs mysql performance comparison

You may want to consider other things...

MySQL adds complexity in that it has several database engines: MyISAM,
InnoDB and MAXDB. All of which have different performance
characteristics. MyISAM is very fast for databases with few
transactions, but InnoDB is more comparable to Postgres in that it
allows superior locking and foreign key integrity etc.

Although not appropriate for a speed comparison, you might want to note
that the use of Mysql versions 4.0 upward now require commercial license
for clients, which are no longer LGPL, whereas Postgres is free (BSD
license). This makes transactions per dollar an interesting statistic
when comparing the Postgres and MySql!

I look forward to seeing the results.

Howard Cole
www.selestial.com

Rick Schumeyer wrote:

> I’m interested in comparing the performance of postgresql and mysql
>
> on various combinations of user loads and database sizes.
>
>