Download List

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 2018-11-13 17:55
pg_hint_plan for PostgreSQL 11 1.3.2 (4 files Hide)

Release Notes

This is pg_hint_plan 1.3.2, the first version for PostgreSQL 11.

No major feature has been added since pg_hint_plan10 1.3.1. Fixed the behavior of GUC variables message_level and parse_messages was fixed since pg_hint_plan10 1.3.1. Behavior of Parallel hint has been changed due to core changes. See commit 5f581e4 for the detail if you are interested in. The new -llvmjit- package is added since this version. It is required addition to mail packge if JIT feature is active.

PostgreSQL 11 向けの初期バージョン pg_hint_plan 1.3.2 をリリースします。

pg_hint_plan10 1.3.1 からの大きな機能変更はありません。GUC変数 message_level と parse_messages の挙動が修正されています。コア側の変更によって Parallel ヒントの挙動が変化しています。変更の詳細な内容が必要であればコミット 5f581e4 を参照してください。 このバージョンより新しいファイル -llvmjit- パッケージが追加されています。このファイルはJIT機能を利用する際に必要となります。


No Changelogs