Re: d25ea01275 and partitionwise join

From: Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>
To: Amit Langote <amitlangote09(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: d25ea01275 and partitionwise join
Date: 2019-07-18 11:10:06
Message-ID: CAPmGK16t-5t3Ut4RB=P0J-2oqS8MCR9F+i9nQM0PO4WmsFa=sg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Jul 18, 2019 at 11:18 AM Amit Langote <amitlangote09(at)gmail(dot)com> wrote:
> On Tue, Jul 16, 2019 at 8:22 PM Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> wrote:
> > On Tue, Jul 2, 2019 at 6:29 PM Amit Langote <amitlangote09(at)gmail(dot)com> wrote:
> > > 0001 - fix partitionwise join to work correctly with n-way joins of
> > > which some are full joins (+ cosmetic improvements around the code
> > > that was touched)
> >
> > Here are my comments about the cosmetic improvements: they seem pretty
> > large to me, so I'd make a separate patch for that.
>
> OK, my bad that I added so many cosmetic changes into a patch that is
> meant to fix the main issue. Just to clarify, I'm proposing these
> cosmetic improvements to better clarify the terminological separation
> between nullable and non-nullable partition keys, which I found a bit
> hard to understand as is.

OK, thanks for the explanation!

> I've broken the patch into two: 0001 contains only cosmetic changes
> and 0002 the fix for handling full joins properly. Would you rather
> that be reversed?

I like this order.

> > In addition, I'd
> > move have_partkey_equi_join() and match_expr_to_partition_keys() to
> > relnode.c, because these functions are only used in that file.
>
> I hadn't noticed that. Makes sense to move them to relnode.c, which
> is implemented in 0001.

Thanks for including that! Will review.

Best regards,
Etsuro Fujita

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Munro 2019-07-18 11:11:08 Re: POC: Cleaning up orphaned files using undo logs
Previous Message Ashutosh Sharma 2019-07-18 11:08:54 Support for CALL statement in ecpg