Just noticed PostgreSQL 8.2 was released yesterday. I chose PostgreSQL 8.x for a large project when MySQL 5 either wasn’t out or was too new for my comfort.
I learned database application programming on MySQL, but now I choose PostgreSQL whenever I have the option. PostrgeSQL is just packed with features that MySQL either doesn’t have or just recently implemented so you need a cutting edge version.
It seems to me that PostgreSQL has a much better user community as well. I know there are many excellent DBA’s using MySQL, but the MySQL community seems dominated by PHP hackers who found MySQL pre-installed on their $5/mo. shared hosting account.
If you’ve never tried PostgreSQL, I highly recommend it, especially if you’ve ever implemented autonumber tables in MySQL to get around flaky autonumber generation. PostgreSQL uses sequences which are basically single field/row tables for maintaining autonumbers. There are a number of sequence related functions in PostgreSQL that makes work with autonumbers not only easy, but also predictable.
Oh and [pgAdmin III] beats MySQL’s awkward and buggy GUI offerings any day.