The biggest gotcha will almost certainly be the lack of any upsert support in PostgreSQL. If you can live without upserts, you'll never look back, IMO.. MySQL

The biggest gotcha will almost certainly be the lack of any upsert support in PostgreSQL. If you can live without upserts, you'll never look back, IMO.. MySQL has a much better GUI based query browser than anything I've seen in the postgres world. Postgres has a very good command line query tool though. But yeah, no upserts.