GNU Info

(mysql.info)Compare PostgreSQL

---

Prev: Compare mSQL Up: Comparisons

---

Enter node , (file) or (file)node

How MySQL Compares to PostgreSQL
--------------------------------

When reading the following, please note that both products are
continually evolving.  We at MySQL AB and the PostgreSQL developers are
both working on making our respective database as good as possible, so
we are both a serious choice to any commercial database.

The following comparison is made by us at MySQL AB.  We have tried to be
as accurate and fair as possible, but because we don't have a full
knowledge of all PostgreSQL features while we know MySQL througly, we
may have got some things wrong.  We will however correct these when they
come to our attention.

We would first like to note that PostgreSQL and MySQL are both widely
used products, but with different design goals, even if we are both
striving to be ANSI SQL compatible.  This means that for some
applications MySQL is more suited, while for others PostgreSQL is more
suited.  When choosing which database to use, you should first check if
the database's feature set satisfies your application.  If you need raw
speed, MySQL is probably your best choice.  If you need some of the
extra features that only PostgreSQL can offer, you should use
`PostgreSQL'.

MySQL-PostgreSQL goals

MySQL and PostgreSQL development strategies

MySQL-PostgreSQL features

Featurewise Comparison of MySQL and PostgreSQL

MySQL-PostgreSQL benchmarks

Benchmarking MySQL and PostgreSQL