Re: add_partial_path() may remove dominated path but still in use

Поиск
Список
Период
Сортировка
Искать
От
Kyotaro HORIGUCHI
Тема
Re: add_partial_path() may remove dominated path but still in use
Дата
Msg-id
20190109.131803.79012001.horiguchi.kyotaro@lab.ntt.co.jp
Ответ на
Список
Дерево обсуждения
add_partial_path() may remove dominated path but still in use Kohei KaiGai <kaigai@heterodb.com>
Re: add_partial_path() may remove dominated path but still in use Tom Lane <tgl@sss.pgh.pa.us>
Re: add_partial_path() may remove dominated path but still in use Kohei KaiGai <kaigai@heterodb.com>
Re: add_partial_path() may remove dominated path but still in use Tom Lane <tgl@sss.pgh.pa.us>
Re: add_partial_path() may remove dominated path but still in use Kohei KaiGai <kaigai@heterodb.com>
Re: add_partial_path() may remove dominated path but still in use Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: add_partial_path() may remove dominated path but still in use Kohei KaiGai <kaigai@heterodb.com>
Re: add_partial_path() may remove dominated path but still in use Robert Haas <robertmhaas@gmail.com>
Re: add_partial_path() may remove dominated path but still in use Kohei KaiGai <kaigai@heterodb.com>
Re: add_partial_path() may remove dominated path but still in use Robert Haas <robertmhaas@gmail.com>
Re: add_partial_path() may remove dominated path but still in use Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: add_partial_path() may remove dominated path but still in use Kohei KaiGai <kaigai@heterodb.com>
Re: add_partial_path() may remove dominated path but still in use Kohei KaiGai <kaigai@heterodb.com>
Re: add_partial_path() may remove dominated path but still in use Amit Kapila <amit.kapila16@gmail.com>
Re: add_partial_path() may remove dominated path but still in use Tom Lane <tgl@sss.pgh.pa.us>
Re: add_partial_path() may remove dominated path but still in use Amit Kapila <amit.kapila16@gmail.com>
Re: add_partial_path() may remove dominated path but still in use Kohei KaiGai <kaigai@heterodb.com>
Re: add_partial_path() may remove dominated path but still in use Amit Kapila <amit.kapila16@gmail.com>
Re: add_partial_path() may remove dominated path but still in use Kohei KaiGai <kaigai@heterodb.com>
Re: add_partial_path() may remove dominated path but still in use Kohei KaiGai <kaigai@heterodb.com>
At Sun, 30 Dec 2018 12:31:22 +0900, Kohei KaiGai  wrote in 
> 2018年12月30日(日) 4:12 Tom Lane :
> 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.

regards.

-- 
Kyotaro Horiguchi
NTT Open Source Software Center


В списке pgsql-hackers по дате отправления
От: Ryan Lambert
Дата:
От: Michael Paquier
Дата:
FAQ