Originally Posted by Nugget
PostgreSQL is such an excellent database. I honestly do not understand why any developer would choose to use MySQL. PostgreSQL is better and free-er.
I've used both. Once I really wanted to use PostgreSQL but we prototyped using each DBMS and fond for our simple application MySQL outperformed PstgreSQL by a factor of more then ten. Basically we were just using a DBMS table as a queue. One writer and mutliple readers. We had a real time application that needed to store snapshots of the current state and there were about 10 readers who woud periodically read out subsets of the data to drive their "real time-ish" displays. we had tens of millions of records per hour.
In our tests, MySQL did the job but as you added more users (readers) PostgreSQL would eventually catch up. It seems postgres was smarter about how it handles locks and multiple readers can share a lock while MySQL did very course grain locking forcing user to wait for locks. It was simpler so it was faster for a low number of users we had.