I'm considering using PostgreSQL for my next Drupal 7 install, as I think it may be faster. I am worried that I may run into issues because PostgreSQL isn't as well supported. I don't want to be surprised after many hours of work by finding out that I can't do something that must be done. Is it easy to switch back to MySQL if I find I've made a mistake? Is PostgreSQL actually faster?
Can you give any advice, or point me to some useful pages?