Re: postgresql vs mysql performance comparison

Marco Colombo wrote:

> If want to develop a commercial application that:
> - runs under Linux - I can;
> - uses HTTP as protocol, and connects to a GPL-ed web server - I can;
> - uses MySQL as a database backend - I can't, unless I rewrite the
>   client library, or buy a commercial licence from them. Why?
>
> With PostgreSQL you don't have to thing about these issues. A big win.
>
> .TM.

1. Even microsoft client libraries are redistributable! The switch from 
LGPL to dual licence for the MySQL client libraries was the sole reason 
that I chose to switch to postgres.

2.  Rick Casey wrote:
    >This will not answer you question, but documents some of the 
evidence for you:
    >
    > http://www.geocities.com/mailsoftware42/db/

These reports have many inconsistencies - speed tests were clearly done 
with MyISAM tables and the nature of the tests clearly is 'read' biased 
with little 'write' - where the MyISAM table level locking really slows 
up MyISAM. Also, many of the feature comparissons are for the InnodB 
engine or for the Beta release of the database.

When Rick Schumeyer does the tests, please could you include some InnoDB 
vs. Postgres benchmarks. I am genuinely interested in the results.


Howard Cole
www.selestial.com