From: | amul sul <sulamul(at)gmail(dot)com> |
---|---|
To: | Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> |
Cc: | Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>, Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>, Rajkumar Raghuwanshi <rajkumar(dot)raghuwanshi(at)enterprisedb(dot)com>, Etsuro Fujita <fujita(dot)etsuro(at)lab(dot)ntt(dot)co(dot)jp>, Dmitry Dolgov <9erthalion6(at)gmail(dot)com>, Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>, Antonin Houska <ah(at)cybertec(dot)at>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [HACKERS] advanced partition matching algorithm for partition-wise join |
Date: | 2019-07-02 04:47:17 |
Message-ID: | CAAJ_b95pZLLSYwNe1LLrCf_2nfK3sQ_RT4DgMzec2xrfa_Oqyg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Attached version is rebase atop of the latest master head(c74d49d41c),
thanks.
Regards,
Amul
On Mon, Jul 1, 2019 at 4:46 PM Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>
wrote:
> On Mon, Jul 1, 2019 at 6:50 PM Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
> wrote:
> > On Sat, May 18, 2019 at 12:20 AM Robert Haas <robertmhaas(at)gmail(dot)com>
> wrote:
> > > On Tue, May 14, 2019 at 12:24 AM Amit Langote
> > > <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> wrote:
> > > > He did mention that cases where the nullable side is provably empty
> can be
> > > > handled by simply returning the path of the non-nullable side with
> > > > suitable projection path added on top to emit NULLs for the columns
> of the
> > > > nullable-side. If we teach populate_joinrel_with_paths() and
> underlings
> > > > about that, then we can allow partitionwise join even in the case
> where
> > > > the nullable side has some partitions missing.
> > >
> > > Yes, I think that would be a good approach to pursue.
> >
> > Hi Ashutosh, Amul, Fujita-san,
> >
> > Could we please have a fresh rebase for the new Commitfest?
>
> Will do unless Ashutosh, Amul, or anyone wants to.
>
> Thanks!
>
> Best regards,
> Etsuro Fujita
>
Attachment | Content-Type | Size |
---|---|---|
0001-Hash-partition-bound-equality-refactoring-v22.patch | application/octet-stream | 5.1 KB |
0002-Partition-wise-join-for-1-1-1-0-0-1-partition-matchi-v22.patch | application/octet-stream | 70.3 KB |
0003-Tests-for-0-1-1-1-and-1-0-partition-matching-v22.patch | application/octet-stream | 213.4 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2019-07-02 05:10:11 | Re: MSVC Build support with visual studio 2019 |
Previous Message | Tom Lane | 2019-07-02 04:01:36 | Re: Add missing operator <->(box, point) |