PostgreSQL versus MySQL (fwd)

[William Lindley]

In response to the earlier question, Scott Walters <phaedrus@illogics.org>
who is not on the PLUG list writes:

--------

PostgreSQL supports triggers, constraints, PL, subqueries, and serveral
other things.

MySQL supports replication, precompiled queries (huge speed up on resident
code), and is optimized for throughput in addition to speed.

Both of them are very fast, and out perform almost all commercial
databases, hands down.

I wouldn't sweat it too much either way unless you specificly need a
feature that only one or the other has. They are both excellent systems.

I'd use MySQL where speed was the biggist factor.

I'd use Postgres where complex reporting or building a large
("Enterprise") data warehouse was the concern.

-scott