專案描述

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.

安裝

pg_hint_planをソースコードからビルドする場合、pg_hint_planのソースを展開したディレクトリで make → make installの順に実行してください。 make installはPostgreSQLをインストールしたOSユーザで実行してく... 顯示如何安裝

用法

pg_hint_planの機能について説明します。 ヒントの記述方法 ヒントはクエリ文字列の先頭のブロックコメント内に記述してください。ブロックコメントをヒントとして認識させるには、ブロックコメントの開始直後に... 顯示用法

下載

win32 Windows pg_hint_plan12-1.3.5-1.el7.x86_64.rpm (日期: 2020-02-21, 大小: 32.65 KB)
macosx Mac pg_hint_plan12-1.3.5-1.el7.x86_64.rpm (日期: 2020-02-21, 大小: 32.65 KB)
linux Linux pg_hint_plan12-1.3.5-1.el7.x86_64.rpm (日期: 2020-02-21, 大小: 32.65 KB)

您的評分
撰寫專案評

使用統計

2017-05-24 19:49
評由 SEAN.KIM

評分:
(9 of 15 people found this review helpful)
It's amazing. We use it to do very effective SQL tuning.

2015-02-09 14:14
評由 Mladen Gogala

評分:
(16 of 22 people found this review helpful)
I tested this on a Postgres database and hints work beautifully. This is a long awaited extension for PgSQL which makes it much more usable.
優點
When time is of the essence, hints are often the only solution. The normal session level commands supported by Postgres are frequently inadequate because all that is needed is to fix a single SQL. Praises and kudos to the authors of this long awaited extension.
缺點
No cons. If the hints are not needed, don't use them.
評列表

最近的活動

2023-01-31
18:20
Use planner hints on PostgreSQL
[待辦事項] Add Comment on ticket #46665
Sorry, this is not a bug but a new feature request.
18:14
Use planner hints on PostgreSQL
[待辦事項] Add Comment on ticket #45644
I had managed to built from source. Please ignore and close this ticket. thanks
18:13
Use planner hints on PostgreSQL
[待辦事項] Add Comment on ticket #45644
I had managed to built from source. Please ignore and close this ticket. thanks
2022-12-19
Show history