Project HP

What is pg_hint_plan?

PostgreSQL executes queries using cost-based planner and sometimes fails to choose execution plan of the lowest cost for some types of queries. In such cases, pg_hint_plan helps users to guide the planner to choose the plans they want by putting some instructions - call them hints - in the comments prefixed to the SQL statement body. No need to rewrite statement itself nor change some GUC parameters elsewhere.


english manual

  1. manual for pg_hint_plan
  2. Hint-list


  1. pg_hint_plan 日本語マニュアル
  2. ヒント一覧


  1. Download

Other info

  1. Project wiki
  2. Newest Source
  3. See also pg_dbms_stats