pg_hint_plan 1.9.0 adds PostgreSQL 19 support and path generation strategies

The pg_hint_plan extension, which allows developers to influence PostgreSQL query execution plans through SQL comment hints, has released version 1.9.0 with PostgreSQL 19 compatibility. This major version adds support for path generation strategies (PGS), a new capability for controlling how the planner generates execution paths. Concurrent minor releases backport bug fixes to PostgreSQL versions 14 through 18, with version 1.4.5 marking the final planned release for PostgreSQL 14.

What's new in pg_hint_plan 1.9.0

• PostgreSQL 19 compatibility: Extension now works with the upcoming PostgreSQL major release
• Path generation strategies (PGS): New major feature for controlling planner path generation behavior
• Bug fixes across release series:
• Fixed infinite loop in hint parser with multi-query strings
• Added CHECK_FOR_INTERRUPTS() in get_hints_from_comment() for better cancellation responsiveness
• Fixed server crash when HintStateDump[2] throws an ERROR
• Restored query ID after SPI execution in get_hints_from_table()
• Corrected schema-qualification of operators for hint table queries
• PostgreSQL 14 end-of-life: Version 1.4.5 is the final planned release for PostgreSQL 14

Why it matters

The PostgreSQL 14 deprecation and PGS feature addition signal ongoing maturation of query hinting capabilities in the PostgreSQL ecosystem, though path generation strategies represent an advanced tuning mechanism primarily relevant to database administrators managing complex query workloads.