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. 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.
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 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
Posted on 2026-10-18 by pg_hint_plan
Related Open Source
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. 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.
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 14, each marked with the following versions:
This is the last release planned for PostgreSQL 14.
Notable changes in this set of releases include the following bug fixes, where applicable:
| # | Наименование новости | Тональность | Информативность | Дата публикации |
|---|---|---|---|---|
| 1 | PostgreSQL 19 RC 1 Released! | 0 | 9.21 | 15-10-2026 |
| 2 | pgAssistant 3.8.0 : continuous improvement loop for Postgres | 0 | 8.24 | 16-09-2026 |
| 3 | pgAdmin 4 v9.18 Released | 0 | 10.22 | 17-09-2026 |
| 4 | pg_utl_smtp v2.0 released | 0 | 8.42 | 18-10-2026 |
| 5 | crecheck v6.0 has been released | 0 | 6.38 | 18-10-2026 |
| 6 | PostgresCompare 1.1.104 Released | 0 | 12.34 | 26-02-2026 |
| 7 | CPU-bound sysbench on a large server: Postgres 12 to 19 beta1 | 0 | 13.06 | 20-06-2026 |
| 8 | PostgreSQL minor release postponed in Q1’ 2026 | 0 | 8.34 | 18-02-2026 |
| 9 | The insert benchmark on a small server, cached workload : Postgres 19 beta1 | 0 | 15.89 | 11-06-2026 |
| 10 | Perseid 0.1.0 is now available | 0 | 7.7 | 14-10-2026 |