Re: benchmarks

Frankyl, Clayton:
Comparing PostgreSQL to MySQL is like comparing an 18-wheel Kenworth
to a Porsche.  The two are not equivalent ... if you want a simple, very
very fast READ-ONLY database, use MySQL.  If you want a full-featured
transaction-environment database for a huge, complex set of data, use
PostgreSQL.
Any benchmarks you find are likely comapring the two for hosting web
sites, which is unfair to PostgreSQL.  If everything your database needs
to do is serve up page content, go for MySQL.  If you've got to build a
60-user inventory management system, MySQL won't even bring you close -
heck, it's not even close to SQL92-compliant.
Oracle is another game altogether, though I can imagine Postgres
catching up in a few years.  Still, the price tag for Oracle weeds out
all but the very serious and deep-pocketed.  And stay away from MS SQL
Server ... I run two of the damn machines, and they're nothing but
grief.
                -Josh
-- 
______AGLIO DATABASE SOLUTIONS___________________________                                       Josh Berkus  Complete
informationtechnology      josh@agliodbs.com   and data management solutions       (415) 436-9166  for law firms, small
businesses      fax  436-0137   and non-profit organizations.       pager 338-4078                               San
Francisco