For me, the only reason to choose PGSQL over MySQL is the sane default – reliability rather than performance - less care, less effort - lower maintenance cost.
Because I’m not an DB expert, and have not enough resource to hire another DB expert to configure db server for me.
If I get a performance issue, which means a great success and much money, then I would hire a db expert and let them to do whatever they want.
For me, the only reason to choose PGSQL over MySQL is the sane default – reliability rather than performance - less care, less effort - lower maintenance cost.
Because I’m not an DB expert, and have not enough resource to hire another DB expert to configure db server for me.
If I get a performance issue, which means a great success and much money, then I would hire a db expert and let them to do whatever they want.