5 ms·
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 acceler
by trympet 3y ago
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 https://ieeexplore.ieee.org/document/9537400
- spudlyo 3y agoIt'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.
- jhas78asd 3y agoThere is a way to provide some type of planner hints https://pghintplan.osdn.jp/pg_hint_plan.html https://pghintplan.osdn.jp/pg_hint_plan.html