Re:Performance: AWS RDS Postgres vs. Digital Ocean Postgres
by atomicity on Wednesday October 23, 2019 @04:20PM
(#21338547)
Definitely interesting how performance between different cloud DB services is so untransparent, similar to object storage [1]. Well, it wouldn't matter much with CSP lockin.
In addition to factors you can't control, maybe Digital Ocean has different Postgres params? I know MySQL for RDS has a bunch of knobs you should tune [2].
Re:Performance: AWS RDS Postgres vs. Digital Ocean Postgres
by atomicity on Wednesday October 23, 2019 @04:38PM
(#21338737)
Yeah, cloud providers do advertise DBaaS as 'simple' but there's a reason they don't advertise anything on parameter tuning or say that they replace DBAs [1]. You pay them so that they give you a self-managed database, but they definitely leave a lot of work on your plate.
In addition to factors you can't control, maybe Digital Ocean has different Postgres params? I know MySQL for RDS has a bunch of knobs you should tune [2].
[1] https://dev.to/sachinkagarwal/public-cloud-object-store-perf... [2] https://aws.amazon.com/blogs/database/best-practices-for-con...
But a managed service means I'm paying you money so you can optimize the database to its fullest for me.
Hopefully DO can improve on its performance overtime.
RL-based tuning might change that soon though: https://github.com/cmu-db/ottertune
[1] https://aws.amazon.com/blogs/database/part-1-role-of-the-dba...