Re: Test patch for partitionwise join with partitioned tables containing default partition

From: Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>
To: Rajkumar Raghuwanshi <rajkumar(dot)raghuwanshi(at)enterprisedb(dot)com>
Cc: Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Test patch for partitionwise join with partitioned tables containing default partition
Date: 2018-06-06 06:02:13
Message-ID: CAFjFpRf=jdAYiBuWGnc2kcRaEtuY8fKnW879HPaC4sePAyGh7Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Thanks Rajkumar for starting a new thread. Please update the
commitfest entry as well.

I have marked this entry as ready for committer, so expecting a
committer to take a look at the patch and commit it.

On Wed, Jun 6, 2018 at 11:26 AM, Rajkumar Raghuwanshi
<rajkumar(dot)raghuwanshi(at)enterprisedb(dot)com> wrote:
> Hi,
>
> As of now partition_join.sql is not having test cases covering cases
> where partition table have default partition, attaching a small test
> case patch to cover those.
>
> Here is a link of previous discussion :
> https://www.postgresql.org/message-id/CAKcux6%3DLO-XK9G0yLe634%2B0SP2UOn5ksVnmF-OntTBOEEaUGTg%40mail.gmail.com
>
> As found by Thomas, The regression test currently fails with v4 patch
> because a
> redundant Result node has been removed from a query plan. here is the
> updated
> v5 patch fixing this.
>
> Thanks & Regards,
> Rajkumar Raghuwanshi
> QMG, EnterpriseDB Corporation

--
Best Wishes,
Ashutosh Bapat
EnterpriseDB Corporation
The Postgres Database Company

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Langote 2018-06-06 06:05:51 Re: why partition pruning doesn't work?
Previous Message Rajkumar Raghuwanshi 2018-06-06 06:01:39 Re: [HACKERS] Partition-wise join for join between (declaratively) partitioned tables