The pg_hint_plan development team is pleased to announce pg_hint_plan 1.7.0. This release of pg_hint_plan adds compatibility with PostgreSQL 17, and includes various improvements and bug fixes. For more details, see the release notes. This new major version includes the following new features:

• Addition of a lexer to parse the query indexes.
• Integration of query IDs with the hint table, instead of normalized strings.
• Removal of pg_hint_plan.hints_anywhere.

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 12, each marked with the following versions:

• pg_hint_plan 1.6.1, compatible with PostgreSQL 16.
• pg_hint_plan 1.5.2, compatible with PostgreSQL 15.
• pg_hint_plan 1.4.3, compatible with PostgreSQL 14.
• pg_hint_plan 1.3.10, compatible with PostgreSQL 12 and 13.

This is the last release planned for PostgreSQL 12.

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

• Revert improvement related to the handling of unavailable indexes in Scan hints. This has proved to cause unwelcome plan instabilities, so this has been removed for all stable branches.
• Handle better the hint table if the extension is not created.
• Various improvements and fixes to documentation and regression test suite.
• Addition of META.json to distribute the module in PGXN.
• Fix crash when retrieving query hint, impacting only PostgreSQL 12 and 13.