Hacker News
new
|
past
|
comments
|
ask
|
show
|
jobs
|
submit
login
trympet
on May 11, 2023
|
parent
|
context
|
favorite
| on:
Ask HN: It's 2023, how do you choose between MySQL...
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
spudlyo
on May 11, 2023
[–]
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.
jhas78asd
on May 12, 2023
|
parent
[–]
There is a way to provide some type of planner hints
https://pghintplan.osdn.jp/pg_hint_plan.html
Guidelines
|
FAQ
|
Lists
|
API
|
Security
|
Legal
|
Apply to YC
|
Contact
Search:
[1] - https://ieeexplore.ieee.org/document/9537400