SV: MySQL and PostgreSQL speed compare

Поиск
Список
Период
Сортировка
От Jarmo Paavilainen
Тема SV: MySQL and PostgreSQL speed compare
Дата
Msg-id 002f01c071a6$010839c0$1501a8c0@comder.private
обсуждение исходный текст
Ответ на Re: MySQL and PostgreSQL speed compare  (Ned Lilly <ned@greatbridge.com>)
Ответы Re: SV: MySQL and PostgreSQL speed compare  ("Dominic J. Eidson" <sauron@the-infinite.org>)
Список pgsql-general
Hi,

...
> Just curious, what kind of tables did you set up in MySQL?  My

Ehh... there are more than one kind... I did not know. Still with
transactions on PostgreSQL (unsafe method?) MySQL was 2 times as fast as
PostgreSQL. I will check this out, and return to this list with the results.

...
> tables, then we're just back at the same old "speed versus data
> integrity" flame war that has always been the base of the
> MySQL/Postgres comparison.

Its a question of a compromising between speed and "integrity". *I think*
PostgreSQL should and could lower their "integrity" a bit (15 times slower).

...
> Of course, if they *were* Berkeley tables and you still got those
> results, then we'll need to dig a little deeper ;-)

I do not know, but I will find out.

// Jarmo

...
> > I wrote a piece of benchmarking, just to test my classes, and
> > was suprised of the speed diffs.
...
> > Inserts on MySQL :      0.71sec/1000 rows
> > Inserts on PostgreSQL:  10.78sec/1000 rows (15 times slower?)
> > Inserts on PostgreSQL*: 1.59sec/1000 rows (2 times slower?)


В списке pgsql-general по дате отправления:

Предыдущее
От: Mirko Zeibig
Дата:
Сообщение: Changes for Foreign Keys from 7.0.3 to 7.1beta?
Следующее
От: "Jarmo Paavilainen"
Дата:
Сообщение: SV: MySQL and PostgreSQL speed compare