There is also Aurora Postgres, though I've heard it still suffers from vacuum issues for some workloads.

In my limited experience DB scaling usually necessitates knowing some specific quirks of whatever implementation is chosen. Otherwise their side effects or sharp edges will cause problems.