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].
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.
3 comments
[ 2.0 ms ] story [ 16.4 ms ] threadIn 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...