• R/O
  • HTTP
  • SSH
  • HTTPS

pg_hint_plan: List of commits

firtst release


RSS
Rev. Time Author
d15acab 2019-01-09 09:59:12 Kyotaro Horiguchi

Call standrad_ProcessUtility when no hook is set

The last commit 2bbb376 forgot the case of no previous hook function
in the ProcessUtility hook function. Fix it.

bc7aa65 2019-01-09 09:58:21 Kyotaro Horiguchi

Call standrad_ProcessUtility when no hook is set

The last commit 3cb8d0b forgot the case of no previous hook function
in the ProcessUtility hook function. Fix it.

0789606 2019-01-09 09:57:34 Kyotaro Horiguchi

Call standrad_ProcessUtility when no hook is set

The last commit dff1e4a forgot the case of no previous hook function
in the ProcessUtility hook function. Fix it.

29972b1 2019-01-09 09:56:21 Kyotaro Horiguchi

Call standrad_ProcessUtility when no hook is set

The last commit 6973627 forgot the case of no previous hook function
in the ProcessUtility hook function. Fix it.

be85d3d 2019-01-09 09:55:02 Kyotaro Horiguchi

Call standrad_ProcessUtility when no hook is set

The last commit c362705 forgot the case of no previous hook function
in the ProcessUtility hook function. Fix it.

5f4e855 2019-01-09 09:35:41 Kyotaro Horiguchi

Call standrad_ProcessUtility when no hook is set

The last commit d5ec243 forgot the case of no previous hook function
in the ProcessUtility hook function. Fix it.

dff1e4a 2019-01-07 19:13:37 Kyotaro Horiguchi

Support prepared statements on extended protocol

However pg_hint_plan doesn't fully consider the extended protocol,
commit 89149ce accidentially broke the case where an analyzed prepared
statement is executed on extended protocol. This patch fixes that only
for the hints-in-comment case. Hint-table still doesn't work in the
case since query-normalization needs Query, which is not available in
planner_hook.

1f00dc6 2019-01-07 19:13:37 Kyotaro Horiguchi

Remove an useless variable

commit 89149ce made the variable stmt_name useless. Remove it.

f5f1326 2019-01-07 19:13:37 Kyotaro Horiguchi

Adjust regression test.

Planning behavior has been changed in core. Adjust regression test.

d5ec243 2019-01-07 19:08:30 Kyotaro Horiguchi

Support prepared statements on extended protocol

However pg_hint_plan doesn't fully consider the extended protocol,
commit c05bb31 accidentially broke the case where an analyzed prepared
statement is executed on extended protocol. This patch fixes that only
for the hints-in-comment case. Hint-table still doesn't work in the
case since query-normalization needs Query, which is not available in
planner_hook.

000d836 2019-01-07 19:08:30 Kyotaro Horiguchi

Remove an useless variable

commit c05bb31 made the variable stmt_name useless. Remove it.

2bbb376 2019-01-07 19:08:18 Kyotaro Horiguchi

Support prepared statements on extended protocol

However pg_hint_plan doesn't fully consider the extended protocol,
commit c05bb31 accidentially broke the case where an analyzed prepared
statement is executed on extended protocol. This patch fixes that only
for the hints-in-comment case. Hint-table still doesn't work in the
case since query-normalization needs Query, which is not available in
planner_hook.

6769ce8 2019-01-07 19:08:18 Kyotaro Horiguchi

Remove an useless variable

commit c05bb31 made the variable stmt_name useless. Remove it.

3cb8d0b 2019-01-07 19:08:05 Kyotaro Horiguchi

Support prepared statements on extended protocol

However pg_hint_plan doesn't fully consider the extended protocol,
commit c05bb31 accidentially broke the case where an analyzed prepared
statement is executed on extended protocol. This patch fixes that only
for the hints-in-comment case. Hint-table still doesn't work in the
case since query-normalization needs Query, which is not available in
planner_hook.

eb5f0ea 2019-01-07 19:08:05 Kyotaro Horiguchi

Remove an useless variable

commit c05bb31 made the variable stmt_name useless. Remove it.

6973627 2019-01-07 19:07:39 Kyotaro Horiguchi

Support prepared statements on extended protocol

However pg_hint_plan doesn't fully consider the extended protocol,
commit 64ab47b accidentially broke the case where an analyzed prepared
statement is executed on extended protocol. This patch fixes that only
for the hints-in-comment case. Hint-table still doesn't work in the
case since query-normalization needs Query, which is not available in
planner_hook.

f1f3627 2019-01-07 19:07:39 Kyotaro Horiguchi

Remove an useless variable

commit 64ab47b made the variable stmt_name useless. Remove it.

c362705 2019-01-07 19:07:10 Kyotaro Horiguchi

Support prepared statements on extended protocol

However pg_hint_plan doesn't fully consider the extended protocol,
commit 3f6c983 accidentially broke the case where an analyzed prepared
statement is executed on extended protocol. This patch fixes that only
for the hints-in-comment case. Hint-table still doesn't work in the
case since query-normalization needs Query, which is not available in
planner_hook.

d615026 2019-01-07 19:07:10 Kyotaro Horiguchi

Remove an useless variable

commit 3f6c983 made the variable stmt_name useless. Remove it.

de6e936 2019-01-07 18:57:53 Kyotaro Horiguchi

Adjust regression test

Core behavior has changed, adjust regression test.

b32d680 2018-12-05 17:32:46 Kyotaro Horiguchi

Fix for union-on-inheritance case

setup_hint_enforcement may pick up a wrong hint when multiple
subqueries access inheritance tables. This leads to failure to apply
hints on other than the first subquery.

0e34503 2018-12-05 17:32:41 Kyotaro Horiguchi

Don't reset plpgsql nest level at every command end

Clean up code for global exit is forgetting about loops that run
hinted commands multiple times. This leads to pg_hint_plan's failure
to affect after the first execution of the inner commands.
The hint below worked only for the first time.

FOR outer IN EXECUTE 'outer-command' LOOP
FOR inner IN EXECUTE '/*+ hint */ inner-command' LOOP
<something>
END LOOP;
END LOOP;

37f3c8c 2018-12-05 17:32:29 Kyotaro Horiguchi

Fix for union-on-inheritance case

setup_hint_enforcement may pick up a wrong hint when multiple
subqueries access inheritance tables. This leads to failure to apply
hints on other than the first subquery.

72333a3 2018-12-05 17:32:21 Kyotaro Horiguchi

Don't reset plpgsql nest level at every command end

Clean up code for global exit is forgetting about loops that run
hinted commands multiple times. This leads to pg_hint_plan's failure
to affect after the first execution of the inner commands.
The hint below worked only for the first time.

FOR outer IN EXECUTE 'outer-command' LOOP
FOR inner IN EXECUTE '/*+ hint */ inner-command' LOOP
<something>
END LOOP;
END LOOP;

3851f42 2018-12-05 17:32:15 Kyotaro Horiguchi

Fix for union-on-inheritance case

setup_hint_enforcement may pick up a wrong hint when multiple
subqueries access inheritance tables. This leads to failure to apply
hints on other than the first subquery.

6b05ac6 2018-12-05 17:32:10 Kyotaro Horiguchi

Don't reset plpgsql nest level at every command end

Clean up code for global exit is forgetting about loops that run
hinted commands multiple times. This leads to pg_hint_plan's failure
to affect after the first execution of the inner commands.
The hint below worked only for the first time.

FOR outer IN EXECUTE 'outer-command' LOOP
FOR inner IN EXECUTE '/*+ hint */ inner-command' LOOP
<something>
END LOOP;
END LOOP;

0eda42b 2018-12-05 17:31:53 Kyotaro Horiguchi

Fix for union-on-inheritance case

setup_hint_enforcement may pick up a wrong hint when multiple
subqueries access inheritance tables. This leads to failure to apply
hints on other than the first subquery.

c9864a4 2018-12-05 17:31:48 Kyotaro Horiguchi

Don't reset plpgsql nest level at every command end

Clean up code for global exit is forgetting about loops that run
hinted commands multiple times. This leads to pg_hint_plan's failure
to affect after the first execution of the inner commands.
The hint below worked only for the first time.

FOR outer IN EXECUTE 'outer-command' LOOP
FOR inner IN EXECUTE '/*+ hint */ inner-command' LOOP
<something>
END LOOP;
END LOOP;

6f23970 2018-12-05 17:31:40 Kyotaro Horiguchi

Fix for union-on-inheritance case

setup_hint_enforcement may pick up a wrong hint when multiple
subqueries access inheritance tables. This leads to failure to apply
hints on other than the first subquery.

d1879e0 2018-12-05 17:31:35 Kyotaro Horiguchi

Don't reset plpgsql nest level at every command end

Clean up code for global exit is forgetting about loops that run
hinted commands multiple times. This leads to pg_hint_plan's failure
to affect after the first execution of the inner commands.
The hint below worked only for the first time.

FOR outer IN EXECUTE 'outer-command' LOOP
FOR inner IN EXECUTE '/*+ hint */ inner-command' LOOP
<something>
END LOOP;
END LOOP;

Show on old repository browser