Bear in mind that Linode's SAS arrays apparently already outperform Digital Ocean's (presumably somewhat crappy) SSD setup, so this may or may not be a silver bullet.

I have a Postgres-based service on a Linode — it works fine in my (mainly read-based) use case, but I do pay for quite a lot of RAM in order to get enough caching.