Projektbeschreibung

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.

Installieren

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

Usage

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

Download

win32 Windows pg_hint_plan11-1.3.4-1.el7.x86_64.rpm (Datum: 2019-01-17, Größe: 32.64 KB)
macosx Mac pg_hint_plan11-1.3.4-1.el7.x86_64.rpm (Datum: 2019-01-17, Größe: 32.64 KB)
linux Linux pg_hint_plan11-1.3.4-1.el7.x86_64.rpm (Datum: 2019-01-17, Größe: 32.64 KB)

Bewertung
Ihr Bewertung
Rezensionen verfassen

Statistiken

2017-05-24 19:49
Rezensionen von SEAN.KIM

Bewertung:
(8 von 14 Personen fanden diese Bewertung hilfreich)
It's amazing. We use it to do very effective SQL tuning.

2015-02-09 14:14
Rezensionen von Mladen Gogala

Bewertung:
(15 von 21 Personen fanden diese Bewertung hilfreich)
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.
Stärken
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.
Schwächen
No cons. If the hints are not needed, don't use them.
Bewertungsliste

Kürzliche Aktivitäten

2019-08-29
20:23
Use planner hints on PostgreSQL
20:22
Use planner hints on PostgreSQL
20:22
Use planner hints on PostgreSQL
20:21
Use planner hints on PostgreSQL
20:21
Use planner hints on PostgreSQL
[Git] commits were pushed to 'pg_hint_plan' (current: 64fe7671a3f6ffc65dd1d8f03f60e627ba17bca0)
Fix is_dummy_rel based on changes in PostgreSQL 10.8 This breaks compatibility with older minor ...
Historie anzeigen