pg_hint_plan v1.9.0 Released

The pg_hint_plan development team is pleased to announce pg_hint_plan 1.9.0. This release of pg_hint_plan adds compatibility with PostgreSQL 19, and includes various improvements and bug fixes. For more details, see the release notes. This new major version includes support for path generation strategies (PGS).

pg_hint_plan is a PostgreSQL extension that offers the possibility to tweak PostgreSQL execution plans using so-called "hints" in SQL comments. For more information, see the project page.

The documentation of the project is published at this page, and is synced up automatically from the source repository.

A new set of minor releases is available down to PostgreSQL 14, each marked with the following versions:

• pg_hint_plan 1.8.1, compatible with PostgreSQL 18.
• pg_hint_plan 1.7.2, compatible with PostgreSQL 17.
• pg_hint_plan 1.6.3, compatible with PostgreSQL 16.
• pg_hint_plan 1.5.4, compatible with PostgreSQL 15.
• pg_hint_plan 1.4.5, compatible with PostgreSQL 14.

This is the last release planned for PostgreSQL 14.

Notable changes in this set of releases include the following bug fixes, where applicable:

• Fix infinite loop with hint parser and multi-query strings
• Add CHECK_FOR_INTERRUPTS() in get_hints_from_comment()
• Ignore indexes without a name, like hypothetical indexes
• Fix server crash when HintStateDump[2] throws an ERROR
• Restore query ID after SPI execution in get_hints_from_table()
• Correct schema-qualification of operators for hint table query
• Add PG_MODULE_MAGIC_EXT
• Update Japanese documentation