Download List

Descripción del Proyecto

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.

Publicado: 2017-05-19 15:30
pg_hint_plan for PostgreSQL 9.4 1.1.4

Nombre Tamaño Hash Fecha Download count
pg_hint_plan94-1.1.4-1.el6.x86_64.rpm 28.66 KB 2017-05-19 15:30 11
pg_hint_plan94-1.1.4-1.el7.x86_64.rpm 31.15 KB 2017-05-19 15:30 13
pg_hint_plan94-1.1.4.tar.gz 175.79 KB 2017-05-19 15:30 27
pg_hint_plan94-debuginfo-1.1.4-1.el6.x86_64.rpm 127.21 KB 2017-05-19 15:30 6
pg_hint_plan94-debuginfo-1.1.4-1.el7.x86_64.rpm 141.88 KB 2017-05-19 15:30 6

Release Notes

pg_hint_plan 1.1.4 released.

  • 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;

pg_hint_plan 1.1.4 リリースします。

  • 比較的複雑なビューやSQL関数を含むクエリを実行するとサーバーがクラッシュする可能性があります。これは以下の手順で再現できます。
    • CREATE EXTENSION pg_hint_plan;
    • SET pg_hint_plan.enable_hint_table TO on;
    • SELECT * FROM information_schema.columns;

Changelog

No Changelogs