Download List


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

發布 2019-01-17 17:45
pg_hint_plan for PostgreSQL 9.6 1.2.5 (3 files 隱藏)


pg_hint_plan96 1.2.5 is released.

Fixed several bugs.

- Fixed failure caused by UNION on inheritance tables.
- Fixed failure caused by prepared statements over extended protocol.
- Fxied failure related to nested PL/PgSQL loops.

pg_hint_plan96 のバージョン 1.2.5 をリリースします


- 継承/パーティションテーブルをUNION内で使用した場合の適用失敗の修正。

- 拡張プロトコル上でプリペアド文を使用した場合の適用失敗の修正。

- PL/PgSQLで多重ループを使った場合などの適用失敗の修正。