OSDN > Trouver un logiciel > Use planner hints on PostgreSQL > Sommaire

Use planner hints on PostgreSQL
Fork

dernière mise à jour: 2023-01-31 18:20

Description du projet
Votre avis sur ce projet Page Web Développeur-Dashboard

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.

Installer

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

Utilisation

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

Télécharger

Windows pg_hint_plan12-1.3.5-1.el7.x86_64.rpm (Date: 2020-02-21, Taille: 32.65 KB)

Mac pg_hint_plan12-1.3.5-1.el7.x86_64.rpm (Date: 2020-02-21, Taille: 32.65 KB)

Linux pg_hint_plan12-1.3.5-1.el7.x86_64.rpm (Date: 2020-02-21, Taille: 32.65 KB)

Dernière Release
- pg_hint_plan for PostgreSQL 13 1.3.7 (Date: 2020-10-30)
- pg_hint_plan for PostgreSQL 12 1.3.7 (Date: 2020-10-30)
- pg_hint_plan for PostgreSQL 11 1.3.7 (Date: 2020-10-30)
- pg_hint_plan for PostgreSQL 9.6 1.2.7 (Date: 2020-08-05)
- pg_hint_plan for PostgreSQL 10 1.3.6 (Date: 2020-08-05)

Download File List

No Image posted

Évaluation

Votre évaluation

Votre avis sur ce projet

5 Étoiles	2
4 Étoiles	0
3 Étoiles	1
2 Étoiles	0
1 Étoile	0

2017-05-24 19:49
Évaluation de SEAN.KIM

Évaluation :

(1$ de 15 personnes ont trouvé cet avis utile)

It's amazing. We use it to do very effective SQL tuning.

2015-02-09 14:14
Évaluation de Mladen Gogala

Évaluation :

(1$ de 22 personnes ont trouvé cet avis utile)

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.

Pros

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.

Cons

No cons. If the hints are not needed, don't use them.

Liste des Évaluations