Re: A problem about partitionwise join

Поиск
Список
Период
Сортировка
От Etsuro Fujita
Тема Re: A problem about partitionwise join
Дата
Msg-id CAPmGK15cnjECPmncz=_JkaaEXnADrvhBYBkB2nCUV8phvc7WhA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: A problem about partitionwise join  (Etsuro Fujita <etsuro.fujita@gmail.com>)
Ответы Re: A problem about partitionwise join
Список pgsql-hackers
Hi Richard,

On Fri, Aug 30, 2019 at 3:08 AM Etsuro Fujita <etsuro.fujita@gmail.com> wrote:
> On Thu, Aug 29, 2019 at 6:45 PM Richard Guo <riguo@pivotal.io> wrote:
> > Attached is a patch as an attempt to address this issue. The idea is
> > quite straightforward. When building partition info for joinrel, we
> > generate any possible EC-derived joinclauses of form 'outer_em =
> > inner_em', which will be used together with the original restrictlist to
> > check if there exists an equi-join condition for each pair of partition
> > keys.
>
> Will review.

I've just started reviewing this patch.  One comment I have for now
is: this is categorized into Bug Fixes, but we have a workaround at
least to the regression test case in the patch (ie, just reorder join
clauses), so this seems to me more like an improvement than a bug fix.

Sorry for the delay.

Best regards,
Etsuro Fujita



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

Предыдущее
От: Antonin Houska
Дата:
Сообщение: Re: Attempt to consolidate reading of XLOG page
Следующее
От: John Naylor
Дата:
Сообщение: Re: benchmarking Flex practices