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
|
Список | 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 по дате отправления: