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

[Jamie McCarthy]

bruce@armintl.com (Bruce Smith) writes:

> 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.