This is a nice question.
Recently I launched a project with Strapi + Postgres.
I chose the Postgres because I have a whitelabel structure based on Postgres schemas(In my opinion, a nice way to scale).
And… I don’t know why, all my tables was deleted many times on deploy process. You can do a search on forum or here on discord database, many people had the same problem.
I changed all the project to use Strapi + MySQL cluster. Now, everything is OK.
Assuming you have experience setting up a robust infrastructure to support your Strapi application, I believe everything will go well.
Try to use something like Kubernetes scaling your application on both ways. horizontal and vertical.