Horton

Re: [HACKERS] advanced partition matching algorithm for partition-wise join

amul sul <sulamul@gmail.com>

View thread
From: amul sul <sulamul@gmail.com>
To: Etsuro Fujita <etsuro.fujita@gmail.com>
Cc: Thomas Munro <thomas.munro@gmail.com>, Robert Haas <robertmhaas@gmail.com>, Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>, Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>, Rajkumar Raghuwanshi <rajkumar.raghuwanshi@enterprisedb.com>, Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>, Dmitry Dolgov <9erthalion6@gmail.com>, Thomas Munro <thomas.munro@enterprisedb.com>, Antonin Houska <ah@cybertec.at>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2019-07-02T04:47:17Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Suppress unused-variable warning.

  2. Allow partitionwise joins in more cases.

  3. Avoid crash in partitionwise join planning under GEQO.

  4. Disable support for partitionwise joins in problematic cases.

  5. Add plan_cache_mode setting

  6. Add test for partitionwise join involving default partition.

  7. Revise API for partition_rbound_cmp/partition_rbound_datum_cmp.

Attachments

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.fujita@gmail.com>
wrote:

> On Mon, Jul 1, 2019 at 6:50 PM Thomas Munro <thomas.munro@gmail.com>
> wrote:
> > On Sat, May 18, 2019 at 12:20 AM Robert Haas <robertmhaas@gmail.com>
> wrote:
> > > On Tue, May 14, 2019 at 12:24 AM Amit Langote
> > > <Langote_Amit_f8@lab.ntt.co.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
>