Re: Parallel Append can break run-time partition pruning

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: Parallel Append can break run-time partition pruning
Дата
Msg-id CAApHDvrAvsiRQs4dA2rX33gD9qpHyHmhgk3ExTwtQdFp8=r0Gw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Parallel Append can break run-time partition pruning  (Amit Langote <amitlangote09@gmail.com>)
Ответы Re: Parallel Append can break run-time partition pruning
Список pgsql-hackers
On Thu, 23 Apr 2020 at 02:37, Amit Langote <amitlangote09@gmail.com> wrote:
> One thing I remain concerned about is that it appears like we are no
> longer leaving the choice between parallel and non-parallel Append to
> the cost machinery which is currently the case.  AFAICS with patched,
> as long as parallel Append is enabled and allowed, it will be chosen
> over a non-parallel Append as the partial path.

Given the same set of paths, when would a non-parallel append be
cheaper than a parallel one? I don't see anything in cost_append()
that could cause the costs to come out higher for the parallel
version. However, I might have misunderstood something. Can you give
an example of a case that you think might change?

The cost comparison is still there for the cheapest parallel safe
normal path vs the cheapest partial path, so, when each of those paths
are allowed, then we will still end up with the cheapest paths for
each child.

> Regarding the patch, I had been assuming that the "pa" in
> pa_subpaths_valid stands for "parallel append", so it using the
> variable as is in the new code structure would be misleading.  Maybe,
> parallel_subpaths_valid?

Yeah, I had wondered if it would be better to rename it, I'd just not
thought too hard on what to call it yet.

David



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Ranier Vilela
Дата:
Сообщение: [PATCH] FIx explicit null dereference pointer (nbtree.c)
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: sqlsmith crash incremental sort