Re: postgresql vs mysql performance comparison - Mailing list pgsql-general

From Howard Cole
Subject Re: postgresql vs mysql performance comparison
Date
Msg-id 422EDA89.50200@selestial.com
Whole thread Raw
In response to Re: postgresql vs mysql performance comparison  (Marco Colombo <pgsql@esiway.net>)
List pgsql-general
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





pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Pgsql dynamic statements and null values
Next
From: Gordan Bobic
Date:
Subject: Triggers and User Defined Trigger Functions