Hacker News Reader

The Postgres query optimizer is more powerful than the MySQL query optimizers [1]. It generally scales better for OLTP. Also tons of extensions that can accelerate your workload.

[1] - https://ieeexplore.ieee.org/document/9537400

View on HN

It's also more opinionated than the MySQL query optimizer, in that you can't give it hints to prevent it from making a horrible mistake.

There is a way to provide some type of planner hints https://pghintplan.osdn.jp/pg_hint_plan.html

Reply on news.ycombinator.com