The pg_hint_plan development team is pleased to announce pg_hint_plan 1.6.0. This release of pg_hint_plan adds compatibility with PostgreSQL 16, and includes various improvements and bug fixes. For more details, see the release notes.

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 now published at this page, and is synced up automatically from the source repository.

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

• pg_hint_plan 1.5.1, compatible with PostgreSQL 15.
• pg_hint_plan 1.4.2, compatible with PostgreSQL 14.
• pg_hint_plan 1.3.9, compatible with PostgreSQL 11, 12 and 13.

This is the last release planned for PostgreSQL 11.

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

• Fix hint stack corruption on ERROR when setting GUCs from Set hints.
• Fix handling of unavailable indexes in Scan hints.
• Reset more aggressively hints for queries executed via extended query protocol.
• Simplify tracking of recursive call depth inside PL/pgSQL functions.
• Bootstrap a new documentation, switching from HTML to markdown with automated publication.