Re: Parallel Append can break run-time partition pruning

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Parallel Append can break run-time partition pruning
Дата
Msg-id 9565.1587598749@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Parallel Append can break run-time partition pruning  (David Rowley <dgrowleyml@gmail.com>)
Ответы Re: Parallel Append can break run-time partition pruning
Список pgsql-hackers
David Rowley <dgrowleyml@gmail.com> writes:
> On Thu, 23 Apr 2020 at 11:11, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Well, anytime the parallel startup cost is significant, for starters.
>> But maybe we account for that at some other point, like when building
>> the Gather?

> Yeah. There's no mention of parallel_setup_cost or parallel_tuple_cost
> in any of the Append costing code. Those are only applied when we cost
> Gather / GatherMerge At the point Amit and I are talking about, we're
> only comparing two Append paths. No Gather/GatherMerge in sight yet,
> so any additional costs from those is not applicable.

Right, so really the costs of partial and non-partial paths are not
commensurable, and comparing them directly is just misleading.
I trust we're not throwing away non-partial paths on that basis?

            regards, tom lane



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

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: Parallel Append can break run-time partition pruning
Следующее
От: Jesse Zhang
Дата:
Сообщение: Re: Header / Trailer Comment Typos for M4 macros