This looks similar to things I've seen before. MyISAM can be made to
look twice as fast as Postgres if the application is cooked to throw
away transaction processing, updates, and referential integrity, none of
which MyISAM seems to support well.
I plan to make a point of this to people, as I personally have
experience working with RDBMSs in the past and understand the importance
of these capabilities. However not everyone I talk to will have any
experiences with databases and understand the issues.
That's why I was looking for a more balanced benchmark that exercises
said capabilities.
-Will
-----Original Message-----
From: Dann Corbit [mailto:DCorbit@connx.com]
Sent: 19 March 2009 18:26
To: Scott Marlowe; Will Rutherdale (rutherw)
Cc: pgsql-general@postgresql.org
Subject: RE: [GENERAL] Is there a meaningful benchmark?
Here is another interesting benchmark with a particular user's
application:
http://blog.page2rss.com/2007/01/postgresql-vs-mysql-performance.html