I’ve now got a tool (almost complete) that slurps in a MySQL DB definition and spits out one for Postgres. I will post a link to it when I get creation of the enum tables working. (Instead of enums, Postgres uses constraints and extra tables.)
www.percona.com/mysql-support/ 24x7, phone-based support for My SQL, Percona Server, Maria DB.
www.pronq.com/Fortify Try Fortify on Demand for Free. Learn How Secure Your Software Is.
www.hazelcast.com/ free 173p Technical eBook on the #1 open source In-Memory Data Grid
www.skysql.com/consulting Looking to get max performance from My SQL? Talk to our team of experts
Eric Hodel has written 3 entries about this goal
I just rewrote all our in-code SQL queries to be easily recognizable. They now all live in
FOO = <<-SQL
WHERE x = 1
This will help us with moving away from MySQL.
Bob has also been exploring Postgres performance, but his results are preliminary