Re: Partition-wise join for join between (declaratively) partitioned tables

From: Rajkumar Raghuwanshi <rajkumar(dot)raghuwanshi(at)enterprisedb(dot)com>
To: Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Partition-wise join for join between (declaratively) partitioned tables
Date: 2016-09-27 07:25:50
Message-ID: CAKcux6kbtccaeBCo5PHmEFCLkGzRfkEggrdpicDMcph=XYk2kA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Sep 22, 2016 at 4:11 PM, Ashutosh Bapat <
ashutosh(dot)bapat(at)enterprisedb(dot)com> wrote:

> The patch is based on sources upto commit
>
> commit 2a7f4f76434d82eb0d1b5f4f7051043e1dd3ee1a
> Author: Heikki Linnakangas <heikki(dot)linnakangas(at)iki(dot)fi>
> Date: Wed Sep 21 13:24:13 2016 +0300
>
> and Amit Langote's set of patches posted on 15th Sept. 2016 [1]
>

I have applied your patch on top of Amit patches posted on 15th Sept. 2016,
and tried to create some test cases on list and multi-level partition based
on test cases written for range partition.

I got some server crash and errors which I have mentioned as comment in
expected output file, which need to be updated once these issues will get
fix. also for these issue expected output is generated by creating same
query for non-partition table with same data.

Attached patch created on top to Ashutosh's patch posted on 22 Sept 2016.

Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation

Attachment Content-Type Size
partition_join_extra_testcases.patch invalid/octet-stream 164.1 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Amul Sul 2016-09-27 07:25:51 Re: Fix some corner cases that cube_in rejects
Previous Message Jeevan Chalke 2016-09-27 07:15:23 Re: Add support for restrictive RLS policies