To me the biggest selling point of MySQL is simplicity, not speed. But
the speed is nice.
Simplicity is in the eye of the beholder. One reason I like PGSQL is
because of its simplicity. When you use MySQL, you have all the
databases in the same server. When you use PGSQL, each database is in
its own server. Log into MySQL and you can see all the other
databases. You can't do that with PGSQL.
I use MySQL for big, industrial sized databases. I also use Oracle for
other big, industrial sized databases. Horses for courses.
Depends on what you mean by 'big, industrial size.' Last time I
checked, which was a couple of versions ago, PGSQL could hold a lot
more data than MySQL. May have changed and I haven't looked at it
recently, but PGSQL also does subselects, user defined datatypes and
user defined functions. PGSQL also has an array datatype, which is
real nifty if you ever have to struggle with data that can't be
normalized.
Don't get me wrong. I like MySQL and am a long time user of MySQL. I
just like PGSQL better. I also like vi better than emacs, Perl better
than Python, and Windows better than Mac, so chalk this up to merely
personal preference.
CC