Recommended persistence layer for production

Is there a recommended persistence layer to use for a temporal production deployment? For example, is there benefits of running mysql over postgres or cassandra over the sql databases. I am curious what others are running in production and what the pros/cons are for running each type of database.

We currently use mysql for our temporal deployment, but we are considering moving to postgres now that it is supported and the team is more familiar with it.

There was a discussion similar to your question, can be useful

cc @Wenquan_Xing in case there is anything additional regarding MySQL vs PostgreSQL