Download List

Sponsored link

Project Description

PostgreSQL executes queries using cost-based optimizer, and sometimes fails to choose most optimized execution plan or 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 nstructions - call them hints - in the comments prefixed to the SQL statement body. No need to rewrite statement tself nor change some GUC parameters elsewhere.

System Requirements

System requirement is not defined

Released at 2013-11-11 19:59
pg_hint_plan for PostgreSQL 9.2 1.1.0 for postgresql92 (2 files Hide)

Release Notes

特殊コメントをプランナに渡せない、ecpg や pl/pgsql でもHintが使用できるように
Query と Hint を関連付ける表を利用して 実行計画を制御でき利用にした。
また、表の結合順序について、outer/inner も含めた順序指定をできるようにした

Changelog

No Changelogs