Skip to content
Projets

ossc-db/pg_hint_plan has 929 GitHub stars and 127 forks. GitHot measured 0 stars in 24 hours. Last checked 2026-11-20 22:23 UTC. Last push 2026-10-15.

Comment ces chiffres sont mesurés

Progression mesurée des étoiles

in 24h
0
in 7 days
Historique en cours
in 15 days
Historique en cours
in 1 month
Historique en cours

Variations nettes sur des périodes qui se chevauchent, pas des totaux quotidiens. Les mesures absentes restent vides. Les étoiles indiquent l’intérêt, pas la qualité.

À propos

Extension adding support for optimizer hints in PostgreSQL

Données

README.md

Original

pg_hint_plan 2.0

pg_hint_plan makes it possible to tweak PostgreSQL execution plans using so-called "hints" in SQL comments, like /*+ SeqScan(a) */.

PostgreSQL uses a cost-based optimizer, that uses data statistics, not static rules. The planner (optimizer) estimates costs of each possible execution plans for a SQL statement, then executes the plan with the lowest cost. The planner does its best to select the best execution plan, but it is far from perfect, since it may not count some data properties, like correlation between columns.

Copyright and license information can be found in the files COPYRIGHT and COPYRIGHT.postgresql.

For more details, please see the various documentations available in the docs/ directory:

  1. Description
  2. The hint table
  3. Installation
  4. Uninstallation
  5. Details in hinting
  6. Errors
  7. Functional limitations
  8. Requirements
  9. Hints list