I switched my Rails development from mysql to postgresql for a few projects now. It's really nice to have sensible index usage, and good in-db fulltext.

I don't have the same comfort level though. I'm not sure how much is my familiarity with mysql, and how much is pg being legitimately harder.