Recommended hosting provider for Postgres

From compose.io:

You can start with 1GB for $17.50/mo and, as your data grows, so does your database for only $12.00 for each additional GB. Your RAM, CPU, and I/O performance increase as your data scales.

Is this for real? 20gb worth of DB would cost you $245.50, and gets you 2gb of ram. AWS at that price is $51.84 /mo for an instance with equivalent ram, and (20*0.1) = 2 dollars a month for the 20gb for a grand total of $53.84.

Compose.io’s slider doesn’t even go above 100gb.

I can’t speak for compose.io, but RDS has been easy to use for us. Daily backups, multi availability zone etc.

Cool. Thanks. I wish AWS pricing was as easy as that to understand though!

Looks like we’ll go with RDS. I thought Compose may have been cheaper

How is the RDS dashboard for monitoring?

I’ve always just hosted my own Postgres, a simple VM if not heavy is still cheaper than any of the above, and for a *BIG* server bare metal will be even more *substantially* cheaper. Just be sure to take backups, even AWS and such are not 'backups.

even AWS and such are not 'backups.

can you elaborate on this?

RDS is great. Amazons Aurora is better. Start with RDS and as soon as you are big enough to justify Aurora, switch.

I switched a 100gb MySQL RDS instance to Aurora last year and it’s been amazing. Zero issues, faster performance, costs cut in half, no need for multiaz for failover sake because the data is already redundant, cache is stored separately and the restart time in the event of a crash is supposed to be < 1 minute. Also automatically grows up to 64TB with no intervention.

Cut costs, improved speed and removed my DBA time. When I heard they were adding Aurora for PG I thought that people were messing with me.

I use Compose. I chose it because I wanted something simple to use and takes care of all the devops-related stuff that comes along with managing a database. The price is alright for smaller datasets but you’re better off looking at alternatives if you need more data.

What sort of price is aurora?

And what additional features does compose give you to help out with the db?

To be honest all hosted offerings are a bit of a joke, RDS 30,000 IOPS for some ungodly amount of money that’s 1/2 of the performance of single low end SSD drive and 1/20 the performance of a decent PCI-E SSD.

This.

I ran a very well used postgresql database on my own hardware for pittence, where on Amazon it would have cost me many $thousands a month, their prices are crazy.

Sure, but at the same time it’s cheaper than a dedicated dev ops person, and you can’t screw it up as badly.