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.

Released at 2017-05-19 14:52
pg_hint_plan for PostgreSQL 9.6 1.2.1

Name Size Hash Date Download count
pg_hint_plan96-1.2.1-1.el7.x86_64.rpm 31.95 KB 2017-05-19 14:52 12
pg_hint_plan96-1.2.1.tar.gz 169.11 KB 2017-05-19 15:33 23
pg_hint_plan96-debuginfo-1.2.1-1.el7.x86_64.rpm 140.15 KB 2017-05-19 14:52 2

Release Notes

pg_hint_plan 1.2.1 released.

  • Two crash bugs are fixed.
    • A bug that a crash can be caused by SQL queries involving rather complex views or SQL functions. You can easily find the bug by the following steps.
      • CREATE EXTENSION pg_hint_plan;
      • SET pg_hint_plan.enable_hint_table TO on;
      • SELECT * FROM information_schema.columns;
  • Parallel hint can cause a crash

pg_hint_plan 1.2.1 リリースします。

  • バグを2件修正しています
    • 比較的複雑なビューやSQL関数を含むクエリを実行するとサーバーがクラッシュする可能性があります。これは以下の手順で再現できます。
      • CREATE EXTENSION pg_hint_plan;
      • SET pg_hint_plan.enable_hint_table TO on;
      • SELECT * FROM information_schema.columns;
  • Paralle ヒントを使った際にクラッシュする可能性があります。

Changelog

No Changelogs