Re: add_partial_path() may remove dominated path but still in use
Kohei KaiGai <kaigai@heterodb.com>
From: Kohei KaiGai <kaigai@heterodb.com>
To: Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2019-01-09T05:44:15Z
Lists: pgsql-hackers
2019年1月9日(水) 13:18 Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>: > > At Sun, 30 Dec 2018 12:31:22 +0900, Kohei KaiGai <kaigai@heterodb.com> wrote in <CAOP8fzY1Oqf-LGdrZT+TAu+JajwPGn1uYnpWWUPL=2LiattjYA@mail.gmail.com> > > 2018年12月30日(日) 4:12 Tom Lane <tgl@sss.pgh.pa.us>: > > On the other hands, the later hook must be dedicated to add regular paths, > > and also provides a chance for extensions to manipulate pre-built path-list > > including Gather-path. > > As long as I know, pg_hint_plan uses the set_rel_pathlist_hook to enforce > > a particular path-node, including Gather-node, by manipulation of the cost > > value. Horiguchi-san, is it right? > > Mmm. I haven't expected that it is mentioned here. > > Actually in the hook, it changes enable_* planner variables, or > directory manipuraltes path costs or even can clear and > regenerate the path list and gather paths for the parallel > case. It will be happy if we had a chance to manpurate partial > paths before genrating gahter paths. > So, is it sufficient if set_rel_pathlist_hook is just relocated in front of the generate_gather_paths? If we have no use case for the second hook, here is little necessity to have the post_rel_pathlist_hook() here. (At least, PG-Strom will use the first hook only.) Thanks, -- HeteroDB, Inc / The PG-Strom Project KaiGai Kohei <kaigai@heterodb.com>
Commits
-
Call set_rel_pathlist_hook before generate_gather_paths, not after.
- dc0eb137fec2 10.7 landed
- 6401583863ea 12.0 landed
- 6257f525aff4 9.6.12 landed
- 027b5a300a9e 11.2 landed