Postgres Pro
Downloads
Home   >   mailing lists

Re: Partition-wise join for join between (declaratively) partitioned tables - Mailing list pgsql-hackers

From Rajkumar Raghuwanshi
Subject Re: Partition-wise join for join between (declaratively) partitioned tables
Date
Msg-id CAKcux6kbtccaeBCo5PHmEFCLkGzRfkEggrdpicDMcph=XYk2kA@mail.gmail.com
Whole thread Raw
In response to Re: Partition-wise join for join between (declaratively) partitioned tables  (Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>)
List pgsql-hackers
Tree view

On Thu, Sep 22, 2016 at 4:11 PM, Ashutosh Bapat <ashutosh.bapat@enterprisedb.com> wrote:
The patch is based on sources upto commit

commit 2a7f4f76434d82eb0d1b5f4f7051043e1dd3ee1a
Author: Heikki Linnakangas <heikki.linnakangas@iki.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

pgsql-hackers by date:

Previous
From: Jeevan Chalke
Date:
Subject: Re: Add support for restrictive RLS policies
Next
From: Amul Sul
Date:
Subject: Re: Fix some corner cases that cube_in rejects