Hacker GitHub

← All repos

ossc-db/pg_hint_plan

View on GitHub ↗ ★ 928 C

Extension adding support for optimizer hints in PostgreSQL

17 mentions on Hacker News by 13 people: 3 stories, 14 comments · first 2019-10-28 · latest 2025-07-05

Mentions per year 17 mentions · busiest year 2022 (6)
20082026
AllStoriesComments NewestTopOldest
  1. You can with the pg_hint_plan extension: https://github.com/ossc-db/pg_hint_plan
    comment by atombender · 2025-07-05 · in How often is the query plan optimal?
  2. …the excellent `pg_hint_plan` extension allows you to specify a complete or partial execution plan: https://github.com/ossc-db/pg_hint_plan
    comment by RMarcus · 2024-04-17 · in Ten years of improvements in PostgreSQL's optimizer
  3. Guessing you've seen this already and it's not doing what you want? https://github.com/ossc-db/pg_hint_plan
    comment by justinclift · 2024-04-14 · in Show HN: PostgreSQL index advisor
  4. …OP) do the simple thing where we specify, for each table, which index to use? I can't find it here https://github.com/ossc-db/pg_hint_plan/blob/master/docs/hin... Because, the mssql WITH(INDEX()) is simple and intuitive. This hint table…
    comment by nextaccountic · 2024-03-17 · in Pg_hint_plan: Force PostgreSQL to execute query plans the way you want
  5. pg_hint_plan —— Give PostgreSQL ability to manually force some decisions in execution plans. https://github.com/ossc-db/pg_hint_plan
    comment by Vonng · 2024-03-15 · in Postgres is eating the database world
  6. …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.
    comment by alyandon · 2023-05-17 · in 10,000x Speedup for Postgres Queries: How to Make a Smart Optimizer More Stupid
  7. https://github.com/ossc-db/pg_hint_plan
    comment by ddorian43 · 2023-01-29 · in Features I'd Like in PostgreSQL
  8. 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…
    comment by jerrysievert · 2022-04-21 · in How Postgres chooses which index to use for a query
  9. …Postgres core as I understand): [1] https://wiki.postgresql.org/wiki/OptimizerHintsDiscussion [2] https://github.com/ossc-db/pg_hint_plan
    comment by tanelpoder · 2022-02-11 · in A Hairy PostgreSQL Incident
  10. You can use pg_hint_plan for hinting query plans to postgres: https://github.com/ossc-db/pg_hint_plan
    comment by rattray · 2022-01-19 · in Tricking PostgreSQL into using an insane, but faster, query plan
  11. There's now a github repo for pg_hint_plan: https://github.com/ossc-db/pg_hint_plan
    comment by rattray · 2022-01-19 · in Tricking PostgreSQL into using an insane, but faster, query plan
  12. 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...
    comment by rattray · 2021-04-06 · in Things I hate about PostgreSQL (2020)
  13. …planner doesn't" which is different from "Make the planner do this thing because I said so". [1] https://github.com/ossc-db/pg_hint_plan/blob/master/doc/pg_h... [2] https://www.postgresql.org/docs/current/runtime-config-query... [3]…
    comment by wireprotocol · 2020-04-04 · in PostgreSQL's Imperfections
  14. 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…
    comment by ants_a · 2019-10-28 · in Show HN: pg_flame – flamegraph visualizations of PostgreSQL query plans