| 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
| 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 |