Re: postgresql vs mysql performance comparison

Поиск
Список
Период
Сортировка
От Howard Cole
Тема Re: postgresql vs mysql performance comparison
Дата
Msg-id 422EDA89.50200@selestial.com
обсуждение исходный текст
Ответ на Re: postgresql vs mysql performance comparison  (Marco Colombo <pgsql@esiway.net>)
Список 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 по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Pgsql dynamic statements and null values
Следующее
От: Gordan Bobic
Дата:
Сообщение: Triggers and User Defined Trigger Functions