Performance: AWS RDS Postgres vs. Digital Ocean Postgres

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].

[1] https://dev.to/sachinkagarwal/public-cloud-object-store-perf... [2] https://aws.amazon.com/blogs/database/best-practices-for-con...

[ Parent | on HN ]

Re:Performance: AWS RDS Postgres vs. Digital Ocean Postgres by jlei523 on Wednesday October 23, 2019 @04:23PM (#21338585)

True.

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.

[ Parent | on HN ]

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.

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...

[ Parent | on HN ]