Kyotaro Horiguchi

Results 9 comments of Kyotaro Horiguchi

I doubt that EXPLAIN or auto_exaplain shows that but setting pg_hint_plan.debug_print=verbose or details shows the log like the follows *if it works correctly*. > 2020-02-14 13:36:59.956 JST [13475] LOG: pg_hint_plan[qno=0xd]:...

(That commit for the master branch is the result of wrongly split of the changes. Code change is contained in the previous commit https://github.com/ossc-db/pg_hint_plan/commit/0576a9485c3289d9a3bc49b63654cf8dcbe3fd04 )

This is not supposed to be placed in contrib directory, and I didn't even tried to build this on Windows but I think it cannot be done a simple way....

(Sorry for late response) Given that it is not a part of system shutdown, the only instance of the cause I know is HA clustering tools.

There was a bug that indexpats are not recreated without parallel hints. The following commit will fix that. Please could you check it? https://github.com/ossc-db/pg_hint_plan/commit/26d0decb8dbb4b75595baafcaca6cab48c0da1c0

How did you install the extension? Specifically I need: The version of the PostgreSQL, including minor version. The version of pg_hint_plan, or the name of RPM package if any. It...

pg_hint_plan applies leading hints by setting a large number (the same value with when enable_* is set to off) to all join types of unwanted join combinations. That cuases the...

Sorry for being late. It'll be soon released.

Thank you for the work and sorry for the long delay. I took a look on this and find it generally fine. [5e48896](https://github.com/ossc-db/pg_hint_plan/pull/107/commits/5e488968810e51e9e22bdda9c5e66f1af0297db3): Mmm. this should be a typo of...