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

Rajkumar Raghuwanshi <rajkumar.raghuwanshi@enterprisedb.com>

View thread View on postgr.es

From: Rajkumar Raghuwanshi <rajkumar.raghuwanshi@enterprisedb.com>

To: Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>

Cc: Robert Haas <robertmhaas@gmail.com>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2016-09-27T07:25:50Z

Lists: pgsql-hackers

Attachments

partition_join_extra_testcases.patch (invalid/octet-stream) patch

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

Commits

Basic partition-wise join functionality.
- f49842d1ee31 11.0 landed
Assorted preparatory refactoring for partition-wise join.
- e139f1953f29 11.0 landed
Teach adjust_appendrel_attrs(_multilevel) to do multiple translations.
- 480f1f4329f1 11.0 landed
Stamp 10beta2.
- 42171e2cd23c 10.0 cited
Eat XIDs more efficiently in recovery TAP test.
- 08aed6604de2 10.0 cited
Abstract logic to allow for multiple kinds of child rels.
- 7a39b5e4d112 10.0 landed
Implement SortSupport for macaddr data type
- f90d23d0c518 10.0 cited
Attempt to stabilize grouping sets regression test plans.
- de4da168d57d 10.0 cited
Teach xlogreader to follow timeline switches
- 1148e22a82ed 10.0 cited
Don't scan partitioned tables.
- d3cc37f1d801 10.0 cited
Fix grammar.
- b4ff8609dbad 10.0 cited
postgres_fdw: Push down FULL JOINs with restriction clauses.
- b30fb56b07a8 10.0 cited
Some preliminary refactoring towards partitionwise join.
- c44c47a773bd 10.0 landed
contrib/amcheck needs RecentGlobalXmin to be PGDLLIMPORT'ified.
- 56018bf26eec 10.0 cited
Print test parameters like "foo: 123", and results like "foo = 123".
- 2a7f4f76434d 10.0 cited