What does HackerNews think of pg_hint_plan?

Give PostgreSQL ability to manually force some decisions in execution plans.

Language: C

10,000x Speedup for Postgres Queries: How to Make a Smart Optimizer More Stupid | May 2023 

  PostgreSQL famously does not support plan hints
I really wish the PostgreSQL core team would acknowledge that their stance on that hurts more than helps. Even Oracle with decades of engineering behind it doesn't get execution plans correct 100% of the time and provides a way to tune query execution via hints.

However, TIL that https://github.com/ossc-db/pg_hint_plan exists so that will probably become a standard thing I deploy.

Features I'd Like in PostgreSQL | Jan 2023
Expand Context ↕
https://github.com/ossc-db/pg_hint_plan
How Postgres chooses which index to use for a query | Apr 2022
Expand Context ↕
there is a maintained index hint extension: https://github.com/ossc-db/pg_hint_plan - at least as far as 13 (and likely 14).

if we're going to talk about index functionality that would be good and effective for Postgres, an index across all partitioned tables (both normal and unique) would be very much welcomed.

the problem is finding someone to maintain it for life.
Troubleshooting a Hairy PostgreSQL Incident - War Story | Feb 2022
Expand Context ↕
Other databases have optimizer hints for that, but apparently there’s resistance to adding hints into Postgres [1]. I find hints very useful (in Oracle world) for quickly working around some optimizer glitch (and figure out the long term solution later).

There actually is a “pg_hint_plan” [2] Postgres module that adds some hints to Postgres optimizer (but it’s not part of Postgres core as I understand):

[1] https://wiki.postgresql.org/wiki/OptimizerHintsDiscussion

[2] https://github.com/ossc-db/pg_hint_plan
Tricking PostgreSQL into using an insane, but faster, query plan | Jan 2022
Expand Context ↕
You can use pg_hint_plan for hinting query plans to postgres: https://github.com/ossc-db/pg_hint_plan
Tricking PostgreSQL into using an insane, but faster, query plan | Jan 2022
Expand Context ↕
There's now a github repo for pg_hint_plan: https://github.com/ossc-db/pg_hint_plan
Things I Hate About PostgreSQL (2020) | Apr 2021
Expand Context ↕
The pg_hint_plan is now being developed on github: https://github.com/ossc-db/pg_hint_plan

I recently put up a PR for a README, you can read it here: https://github.com/ossc-db/pg_hint_plan/blob/8a00e70c387fc07...
Show HN: pg_flame – flamegraph visualizations of PostgreSQL query plans | Oct 2019
Expand Context ↕
There is one implementation of hints available as an extension: https://github.com/ossc-db/pg_hint_plan

It's unfortunate that it comes off as if maintainers think planner is good enough, because that is demonstrably not true. And from my discussions there is wide agreement that the planner will never be perfect. But agreeing that it's something that needs work is not enough, someone actually has to do the work too. Reality is that implementing any feature to PostgreSQL quality standards is hard work.