PostgreSQL で ヒント句を使う

Fork

pg_hint_plan11 1.3.5 is released.

The following bugs are fixed in this version.

• Fixed a bug that hints on queries in PL/pgSQL doesn't go in effect.
• Fixed a bug that the combination of PL/pgSQL function and savepoint can cause a crash.
• Fixed a bug that PREPAREd query can cause a crash when the objects required by the query is dropped.
• Fixed Rows() hint parsing. Rows hint with an empty parentheses lead to a crash.
• Fixed that a bug that a query without a hint in a nested-planned query can cancel the hints on the immediately-upper planning. The crash is caused not only by PL/pgSQL functions but also by extensions that does SPI calls while planning.
• Fixed a bug that can cause a crash when table hints is enabled https://github.com/ossc-db/pg_hint_plan/issues/25. Psql doesn't that by default but escaped semicolons are sent as a part of a query.
• Fixed the bug that Parallel hints can set parallel_tuple_cost to zero wrongly while planning.