OSDN Git Service

Make HashJoin hint more coercive.
authorKyotaro Horiguchi <horikyoga.ntt@gmail.com>
Thu, 29 Oct 2020 00:59:35 +0000 (09:59 +0900)
committerKyotaro Horiguchi <horikyoga.ntt@gmail.com>
Thu, 29 Oct 2020 12:12:16 +0000 (21:12 +0900)
commit0fe27602c9c1f41e066901c20800fdec6f9ac184
tree977762a1b908333fb20612700412589592006b35
parent01adeac101d306f8bf78f221b50c81727a8d9c45
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.
pg_hint_plan.c