---
title: "pg_hint_plan v1.9.0 Released - Angryecho"
description: "pg_hint_plan v1.9.0 Released 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…"
canonical_url: "https://www.angryecho.com/c/shu_ju_ku/p/P2TBBjknJkBZzUoELZJU7"
meta:
  "og:description": "pg_hint_plan v1.9.0 Released 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…"
  "og:image": "https://www.angryecho.com/_og/d/c_Post%2Ctitle_~5ZCQ5qe9572R%2Cdescription_~5ZCQ5qe95LiA5LiL77yM5bCx5LiK5ZCQ5qe9572R44CC%2CpostId_P2TBBjknJkBZzUoELZJU7%2Crevision_~MjAyNi0xMC0yNVQwMjo1Nzo1MC4xODM3Nzla%2Cp_Ii9jL3NodV9qdV9rdS9wL1AyVEJCamtuSmtCWnpVb0VMWkpVNyI%2Cs_gKOerf7JbTqW-a5U.png"
  "og:image:height": "630"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "pg_hint_plan v1.9.0 Released"
---

> Index of every page on this site: [llms.txt](https://www.angryecho.com/llms.txt)

# **pg\_hint\_plan v1.9.0 Released**

# pg\_hint\_plan v1.9.0 Released

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

> 原文： [PostgreSQL News｜pg\_hint\_plan v1.9.0 Released](https://www.postgresql.org/about/news/pg_hint_plan-v190-released-3408/)，2026-10-18

排序方式 :

### **成为第一条评论！**

Nobody's responded to this post yet. Add your thoughts and get the conversation going.

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://www.angryecho.com/c/shu_ju_ku/p/P2TBBjknJkBZzUoELZJU7#post","@type":"DiscussionForumPosting","commentCount":0,"dateModified":"2026-10-25T02:57:50.183Z","datePublished":"2026-10-18T04:00:00.000Z","description":"pg_hint_plan v1.9.0 Released 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…","headline":"pg_hint_plan v1.9.0 Released","isPartOf":"https://www.angryecho.com/c/shu_ju_ku","mainEntityOfPage":"https://www.angryecho.com/c/shu_ju_ku/p/P2TBBjknJkBZzUoELZJU7","text":"pg_hint_plan v1.9.0 Released\n\nPosted on 2026-10-18 by pg_hint_plan\n\nRelated Open Source\n\nThe 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).\n\npg_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.\n\nThe documentation of the project is published at this page, and is synced up automatically from the source repository.\n\nA new set of minor releases is available down to PostgreSQL 14, each marked with the following versions:\n\n\n\n\n\npg_hint_plan 1.8.1, compatible with PostgreSQL 18.\n\n\n\npg_hint_plan 1.7.2, compatible with PostgreSQL 17.\n\n\n\npg_hint_plan 1.6.3, compatible with PostgreSQL 16.\n\n\n\npg_hint_plan 1.5.4, compatible with PostgreSQL 15.\n\n\n\npg_hint_plan 1.4.5, compatible with PostgreSQL 14.\n\nThis is the last release planned for PostgreSQL 14.\n\nNotable changes in this set of releases include the following bug fixes, where applicable:\n\n\n\n\n\nFix infinite loop with hint parser and multi-query strings\n\n\n\nAdd CHECK_FOR_INTERRUPTS() in get_hints_from_comment()\n\n\n\nIgnore indexes without a name, like hypothetical indexes\n\n\n\nFix server crash when HintStateDump[2] throws an ERROR\n\n\n\nRestore query ID after SPI execution in get_hints_from_table()\n\n\n\nCorrect schema-qualification of operators for hint table query\n\n\n\nAdd PG_MODULE_MAGIC_EXT\n\n\n\nUpdate Japanese documentation\n\n\n\n原文：PostgreSQL News｜pg_hint_plan v1.9.0 Released，2026-10-18","url":"https://www.angryecho.com/c/shu_ju_ku/p/P2TBBjknJkBZzUoELZJU7","author":{"@type":"Person","name":"UID:67155856","url":"https://www.angryecho.com/u/NGA67155856"},"interactionStatistic":[{"@type":"InteractionCounter","interactionType":"https://schema.org/LikeAction","userInteractionCount":0},{"@type":"InteractionCounter","interactionType":"https://schema.org/DislikeAction","userInteractionCount":0},{"@type":"InteractionCounter","interactionType":"https://schema.org/ViewAction","userInteractionCount":0},{"@type":"InteractionCounter","interactionType":"https://schema.org/ShareAction","userInteractionCount":0}]}]}
```

## Sitemap

See the full [sitemap](https://www.angryecho.com/sitemap.md) for all pages.