pg_hint_plan v1.9.0 Released

From: pg_hint_plan via PostgreSQL Announce <announce-noreply(at)postgresql(dot)org>
To: PostgreSQL Announce <pgsql-announce(at)lists(dot)postgresql(dot)org>
Subject: pg_hint_plan v1.9.0 Released
Date: 2026-10-18 02:04:03
Message-ID: 179228904324.1207778.15962851507888020600@wrigleys.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-announce

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](https://github.com/ossc-db/pg_hint_plan/releases). 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](https://github.com/ossc-db/pg_hint_plan/).

The documentation of the project is published at [this page](https://pg-hint-plan.readthedocs.io/), 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

Browse pgsql-announce by date

  From Date Subject
Next Message PostgreSQL Europe via PostgreSQL Announce 2026-10-18 03:04:04 FOSDEM PGDay 2027: two days of PostgreSQL, with calls for papers and sponsors now open!
Previous Message HexaCluster via PostgreSQL Announce 2026-10-18 01:04:03 crecheck v6.0 has been released