There are decades of accumulated knowledge in optimizing relational databases like PostgreSQL, and so much of it is either unhelpful or downright counterproductive in modern, resource-contentious, cloud-based environments. Disks aren’t disks any more, RAM might not be RAM, and latency has become more than intermittent.
This video discusses the MySQL and PostgreSQL Cloud offerings and shows the dark side of this strategy like performance problems or the fact that virtualization doesn’t magically give you extra IO on your storage.
Heroku runs the largest PostgreSQL service in the world, currently hosting more than 175,000 databases for web applications. Recently this database service was opened up to the world, making it available to anyone looking for a production-ready database server for their application.