4 ms·
> dirt simple managed Postgres Heroku PostgreSQL is very simple, yes. But once you need non-trivial scale it's expensive and extremely non-performant. Even a
by VWWHFSfQ 4y ago
> dirt simple managed Postgres
Heroku PostgreSQL is very simple, yes. But once you need non-trivial scale it's expensive and extremely non-performant. Even a medium-sized RDS will outperform Heroku's most expensive database offering by 20x in my experience. My company doesn't even run PG on Heroku anymore. We have a VPC/Private Space connection to AWS Aurora because the cost/performance difference is so extreme.
- snacktaster 4y agoI don't know the details of how Heroku implements their hosted postgres service, but I'm _guessing_ that it's just a bunch of PG servers running on EC2 instances. There's probably a lot of CPU stealing "noisy neighbors" going on. But yeah, I've also experienced Heroku's PG databases being dog-slow compared to RDS for the same workloads.
- mixmastamyk 4y agoThey're probably using older or cheaper instance types. By not upgrading while charging the same or more over time, one can skim more profit.
- karmelapple 4y agoI have run the experiment, and Crunchy Data’s Postgres servers are 4X more bang for the buck than Heroku’s. I let some folks at Heroku know this who are product managers, and they are investigating it… but I would be shocked if Heroku gets a big performance improvement anytime in, say, 2023. 20X seems like a lot for RDS, though I’d be curious to learn more! We are switching to Crunchy because of that clear cost/performance difference you mention.
- jrochkind1 4y agoI would be kind of shocked if heroku gets a big performance improvement ever again. It seems the owners have decided to basically freeze it.