• R/O
  • HTTP
  • SSH
  • HTTPS

pg_hint_plan: List of commits

firtst release


RSS
Rev. Time Author
437a4fa master 2021-10-06 11:57:29 Kyotaro Horiguchi

Allow run make check of PostgreSQL with loading pg_hint.plan

Automatically switch environment when pg_hint_plan is installed as a
part of "make check" of PostgreSQL. That test is executed with the
following command line in the top directory of PostgreSQL tree.

make check EXTRA_INSTALL=<this directory> EXTRA_REGRESS_OPTS="--temp-config <this directory>/pg_hint_plan.conf"

make check-world fails for test that requires extra modules.

3d8c7b8 2021-10-06 11:57:29 Kyotaro Horiguchi

Support "Memoize" Hint.

PostgreSQL 14 introduced the new optimization item "memoize", which
allows a join to memoize the inner result. Add a hint to control this
feature.

454f72a 2021-10-06 11:56:12 Kyotaro Horiguchi

Support PostgreSQL 14

In PostgreSQL 14, planner was restructured in regard to query string
passing. This change allows us to remove fair amount of lines and
complexity that had been added as a struggle for retrieving proper
query string.

Two callbacks, post_parse_analyze_hook and ProcessUtility_hook are no
longer used. get_query_string is removed altogether. Also
current_hint_retrieved juggling, which was complex and fragile,
disappears. Now pg_hint_plan_planner alone can retrieve hint string by
looking into the given string.

In PostgreSQL 14, a new optimization item "memoize" is added. It is
not handled in this commit and leave it for a later commit.

a60dec0 PG10 2020-10-29 21:20:30 Kyotaro Horiguchi

Fix bogus upgrade scripts.

306be8a 2020-10-29 21:20:30 Kyotaro Horiguchi

Update core.c and make_join_rel.c.

From this version core.c and make_join_rel.c are automatically
generated from core code. Adjust them to auto-generated content.

beb6a85 2020-10-29 21:20:30 Kyotaro Horiguchi

New tool to generate source files for copied functions

Previously core.c and make_join_rel.c are maintained by hand. This
tool generates the files from corresponding core source files.

c3634a9 2020-10-29 21:19:38 Kyotaro Horiguchi

Follow a behavioral change in core.

Commit e22e29c258 has changed the core's behavior of naming indexes.
Follow the changes. This is regression-result changes only.

a797bcf PG11 2020-10-29 21:12:16 Kyotaro Horiguchi

Change version to 1.3.7.

Fixed bogus upgrade scripts on the way changing version.

0fe2760 2020-10-29 21:12:16 Kyotaro Horiguchi

Make HashJoin hint more coercive.

Even with HashJoin hint, hash joins may be rejected by planner if hash
table for the inner-rel is estimated too large. Make HashJoin hint
more coercive by temporarily increasing work_mem. This change affects
only join-searching so no significant side-effects are expected.

01adeac 2020-10-29 21:12:16 Kyotaro Horiguchi

Fix tested OS version to CentOS 8.2

e600d83 2020-10-29 21:12:16 Kyotaro Horiguchi

Change copyright year of docs to 2020

afe29b4 PG12 2020-10-29 21:09:36 Kyotaro Horiguchi

Change version to 1.3.7.

4e6f85c 2020-10-29 21:09:36 Kyotaro Horiguchi

Make HashJoin hint more coercive.

Even with HashJoin hint, hash joins may be rejected by planner if hash
table for the inner-rel is estimated too large. Make HashJoin hint
more coercive by temporarily increasing work_mem. This change affects
only join-searching so no significant side-effects are expected.

ffeaeea 2020-10-29 21:09:36 Kyotaro Horiguchi

Change copyright year of docs to 2020

beb3179 2020-10-29 21:08:29 Kyotaro Horiguchi

Fix document bugs.

Some stale descriptions were left in the docs. Fix them.

4ffa97e PG13 2020-10-29 21:03:05 Kyotaro Horiguchi

Change version to 1.3.7.

e891d54 2020-10-29 21:03:05 Kyotaro Horiguchi

Make HashJoin hint more coercive.

Even with HashJoin hint, hash joins may be rejected by planner if hash
table for the inner-rel is estimated too large. Make HashJoin hint
more coercive by increasing hash_mem_multiplier.

adc7ca8 2020-10-29 21:03:05 Kyotaro Horiguchi

Change copyright year of docs to 2020

7392b37 2020-10-29 20:31:47 Kyotaro Horiguchi

Stabilize regression test.

I was annoyed by frequent nonsubstantial change of title line length
of explain output. This commit makes maskout.sh replace the title
lines with fixed content.

8286b67 2020-10-29 20:31:47 Kyotaro Horiguchi

Follow a behavioral change in core.

Commit 894f5dea76 has changed the core's behavior of naming indexes.
Follow the changes. This is regression-result changes only.

16ae4df 2020-10-29 20:31:47 Kyotaro Horiguchi

Update core.c and make_join_rel.c.

From this version core.c and make_join_rel.c are automatically
generated from core code. Adjust them to auto-generated content.

2b4d65f 2020-10-29 20:31:47 Kyotaro Horiguchi

New tool to generate source files for copied functions

Previously core.c and make_join_rel.c are maintained by hand. This
tool generates the files from corresponding core source files.

7192693 2020-10-29 20:31:47 Kyotaro Horiguchi

Add *.bc to .gitignore

Added *.bc and *~ to .gitignore

5f0969f 2020-10-29 20:31:47 Kyotaro Horiguchi

Follow the semantic change of pg_list part 2

Commit 7ed93ce forgot to fix another place where list_delete_cell() is
used. Fix it.

8a9ac56 2020-10-29 20:30:12 Kyotaro Horiguchi

Stabilize regression test.

I was annoyed by frequent nonsubstantial change of title line length
of explain output. This commit makes maskout.sh replace the title
lines with fixed content.

33943ba 2020-10-29 20:30:12 Kyotaro Horiguchi

Follow a behavioral change in core.

Commit d9253df12e has changed the core's behavior of naming indexes.
Follow the changes. This is regression-result changes only.

874bc3a 2020-10-29 20:30:12 Kyotaro Horiguchi

Update core.c and make_join_rel.c.

From this version core.c and make_join_rel.c are automatically
generated from core code. Adjust them to auto-generated content.

8deda1b 2020-10-29 20:30:12 Kyotaro Horiguchi

New tool to generate source files for copied functions

Previously core.c and make_join_rel.c are maintained by hand. This
tool generates the files from corresponding core source files.

7a9a406 2020-10-29 20:29:28 Kyotaro Horiguchi

Stabilize regression test.

I was annoyed by frequent nonsubstantial change of title line length
of explain output. This commit makes maskout.sh replace the title
lines with fixed content.

634d207 2020-10-29 20:29:28 Kyotaro Horiguchi

Follow a behavioral change in core.

Commit 3737965249 has changed the core's behavior of naming indexes.
Follow the changes. This is regression-result changes only.

Show on old repository browser