pg_hint_plan12 1.3.9 is released

pg_hint_plan12 1.3.9 is released. This version only supports PostgreSQL 12.

Some changes are made in this release:

• Fix hint stack corruption on ERROR when setting GUCs from Set hints (Michael Paquier: 253c6be)
• Fix crash with IndexScan hints and ordering properties of index AMs (Masahiro Ikeda: dfb7d34)
• Reset more aggressively hints for queries executed via extended query protocol (tanujnay112: 4d274fb)
• Add EXPLAIN (COSTS false) to some tests (Masahiro Ikeda: ae955e3)

pg_hint_plan11 1.3.9 is released

pg_hint_plan11 1.3.9 is released. This version only supports PostgreSQL 11. This is the last release of pg_hint_plan for this version of PostgreSQL.

Some changes are made in this version:

• Fix hint stack corruption on ERROR when setting GUCs from Set hints (Michael Paquier: 14ee853)
• Fix crash with IndexScan hints and ordering properties of index AMs (Masahiro Ikeda: a68d79b)
• Reset more aggressively hints for queries executed via extended query protocol (tanujnay112: 9e77aee)
• Add EXPLAIN (COSTS false) to some tests (Masahiro Ikeda: c3bc533)

pg_hint_plan15 1.5 is released

pg_hint_plan15 1.5 is released. This version only supports PostgreSQL 15. This is the first release of pg_hint_plan for this version of PostgreSQL.

Some changes are made in this release:

• Improve handling of hints with PL/pgsql functions (Michael Paquier: a9863af)
• Add support for hints with array parameters in PREPARE statements (WinterUnicorn: 7c03155)
• Adjust check in pg_hint_plan_set_rel_pathlist() (Michael Paquier: 8be4662)
• Fix a crash bug of IndexScan hint (Ideriha Takeshi: 23cabaf)
• Properly free all elements in a list (Kyotaro Horiguchi: e6a9004)
• Fix extension scripts to support all possible upgrade paths (Michael Paquier: 575288f)
• Improve portability of the regression tests (Kyotaro Horiguchi, Masahiro Ikeda, Michael Paquier: 436c0b1, 7e423a3, ff2d410, 8e1bb71)

This page has been updated on July 5th, 2023.

• Added rpm packages for RHEL/CentOS 7

pg_hint_plan14 1.4.1 is released

pg_hint_plan14 1.4.1 is released. This version only supports PostgreSQL 14.

Some changes are made in this version:

• Improve handling of hints with PL/pgsql functions (Michael Paquier: e7d283d)
• Fix extension scripts to support all possible upgrade paths (Michael Paquier: 67c2489)
• Add CI tests using github actions (Masahiko Sawada: 9b8bcbf)
• Improve portability of the regression tests (Michael Paquier: 6afb575, c40b62b, 0f3d2c5)

This page has been updated on July 5th, 2023.

• Added rpm packages for RHEL/CentOS 7

pg_hint_plan13 1.3.8 is released

pg_hint_plan13 1.3.8 is released. This version only supports PostgreSQL 13.

Some changes are made in this version:

• Improve handling of hints with PL/pgsql functions (Michael Paquier: 7883b6a)
• Fix debug level check in restrict_indexes (Kyotaro Horiguchi: 7d53b12)
• Ignore non-existent prepared statement in get_query_string (Kyotaro Horiguchi: 041f948)
• Properly free all the elements in the hint list (Kyotaro Horiguchi: 49c46c7)
• Use standard way of deleting list cells (Maxim Orlov: d5f21cc)
• Fix extension scripts to support all possible upgrade paths (Michael Paquier: 66a3595)
• Add call to EmitWarningsOnPlaceholders() after defining custom GUCs (Michael Paquier: b89a814)
• Docs: Fix default value for pg_hint_plan.message_level (Michael Paquier: acaf724)
• Add support for github actions (Masahiko Sawada: 66c5fa6)
• Improve portability of the regression tests (Kyotaro Horiguchi, Masahiro Ikeda, Michael Paquier: 104bc7c, 71a81b2, bc95bbb, 1bb41ee)

This page has been updated on July 5th, 2023.

• Added rpm packages for RHEL/CentOS 7

pg_hint_plan12 1.3.8 is released

pg_hint_plan12 1.3.8 is released. This version only supports PostgreSQL 12.

Some changes are made in this version:

• Improve handling of hints with PL/pgsql functions (Michael Paquier: 2bcdfd)
• Ignore non-existent prepared statement in get_query_string (Kyotaro Horiguchi: 904a4fc)
• Fix extension scripts to support all possible upgrade paths (Michael Paquier: d6433e2)
• Properly free all the elements in the hint list (Kyotaro Horiguchi: 51460b6)
• Add call to EmitWarningsOnPlaceholders() after defining custom GUCs (Michael Paquier: 0820825)
• Add support for github actions (Masahiko Sawada: 0115589)
• Improve portability of the regression tests (Kyotaro Horiguchi, Masahiro Ikeda, Michael Paquier: 3be9316, d8b0de4, 1a90022, 41c7c75, 7709e17)
• Docs: Fix default value for pg_hint_plan.message_level (Michael Paquier: 6efcf55)

This page has been updated on July 5th, 2023.

• Added rpm packages for RHEL/CentOS 7

pg_hint_plan11 1.3.8 is released

pg_hint_plan11 1.3.8 is released. This version only supports PostgreSQL 11.

Some changes are made in this version:

• Ignore non-existent prepared statement in get_query_string (Kyotaro Horiguchi: 904a4fc)
• Improve handling of hints in PL/pgsql functions (Michael Paquier: 2bcdfd0)
• Fix extension scripts to support all possible upgrade paths (Michael Paquier: 8aadccb)
• Properly free all the elements in the hint list (Kyotaro Horiguchi: 51460b6)
• Improve portability of the regression tests (Kyotaro Horiguchi, Masahiko Ikeda, Michael Paquier: 3be9316, d8b0de4, 1a90022, 41c7c75, 7709e17
• Add support for github actions (Masahiko Sawada: f686c56)
• Docs: Fix default value for pg_hint_plan.message_level (Michael Paquier: 6efcf55)
• Add call to EmitWarningsOnPlaceholders() after defining custom GUC (Michael Paquier: 0820825)

This page has been updated on July 5th, 2023.

• Added rpm packages for RHEL/CentOS 7

pg_hint_plan10 1.3.7 is released

pg_hint_plan10 1.3.7 is released. This version only supports PostgreSQL 10. This is the last release of pg_hint_plan for this version of PostgreSQL.

Some changes are made in this version:

• Ignore non-existent prepared statement in get_query_string (Kyotaro Horiguchi: 353c365)
• Fix extension scripts to support all possible upgrade paths (Michael Paquier: fec368b)
• Docs: Fix default value for pg_hint_plan.message_level (Michael Paquier: 02353c5)
• Properly free all the elements in the hint list (Kyotaro Horiguchi: 16e7a16)
• Add call to EmitWarningsOnPlaceholders() after defining custom GUCs (Michael Paquier: 2dc6f42)
• Add support for github actions (Masahiko Sawada: de86c26)
• Improve portability of the regression tests (Kyotaro Horiguchi, Masahiro Ikeda, Michael Paquier: 6b5bcd, 70db487, e8d7abe, d8e3654)

This page has been updated on July 5th, 2023.

• Added rpm packages for RHEL/CentOS 7

pg_hint_plan14 1.4 is released

pg_hint_plan14 1.4 is released. This version only supports PostgreSQL 14.

Some changes are made in this version.

• Added Memoize hint.
• Now pg_hint_plan uses the in-core queryid for query normalization in the hint-table feature. compute_query_id is required to be auto or on if the feature is turned on.
• Added a new GUC variable pg_hint_plan.hints_anywhere. If it is on, pg_hint_plan searches for hints ignoring SQL syntax, specifically, even in text literals.

This page is updated at June 30th.

• Added rpm packages for RHEL/CentOS 7