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
