[KLUG Members] MySQL -vs- Postgresql - speed.

members@kalamazoolinux.org members@kalamazoolinux.org
Sun, 27 Oct 2002 17:33:44 -0500


>>I've read that Postgresql may be a little slower than MySQL,
>>but that's not "a little slower", that's a LOT SLOWER!
>There are usually ways to improve speed on any database, but bottom
>line, yes Postgres is a lot slower.
>Postgres's atomicity is more robust.  MySQL is much faster.
>Postgres provides rollbacks.  MySQL is much faster.
>Postgres (probably) won't leave your DB in an inconsistent state if
>you yank the plug during a sequence of updates. MySQL is much
>faster.
>And so on.  :)
>Also, MySQL is undergoing more rapid development, there are some
>exciting improvements happening.

Watching MySQL development is a little bewildering.  By adding transactions,
foreign keys, contraints, triggers, etc... (all the features a "real" RDBMS has)
will inevitably result in one thing - larger & slower.  It will just be another
PostgreSQL (or Informix, or Oracle, or M$-SQL),  and it seems like it will have
evolved itself right out of its niche (light and just bloody fast).

Do they have a plan to avoid this?