Comment by paulryanrogers

I've used Pg since 2005. In 2025 my team finally had to resort to pg_hint_plan, which I had thankfully already allow-listed. It was a lifesaver when the planner just wouldn't use the optimal index.

(Seen at least two occasions where MySQL needed hints, and once where it needed odd bool and date comparisons.)

Looking forward to dropping the hint as soon as a new, major Pg version no longer needs it.