Earlier quoted context omitted.
So you'd rather self host a database as well? How do you prevent data loss? Do you run a whole database cluster in multiple physical locations with automatic failover? Who will spend time monitoring replication lag? Where do you store backups? Who is responsible for tuning performance settings?
Hosting a database is no different than self-hosting any other service. This viewpoint hath what cloud wrought, this atrophying of the most basic operational skills, as if running these magic services are only achievable by the hyperscalers who said they are the only ones capable. The answers to all of your questions are a hard: it depends. What are your engineering objectives? What are your business requirements? Up…
But that said, you can afford a lot more hardware if you’re not using RDS, so the tuning doesn’t need to be perfect.