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: pgsql-hackers <pgsql-hackers@postgresql.org>, Robert Haas <robertmhaas@gmail.com>

Date: 2017-03-21T10:22:13Z

Lists: pgsql-hackers

Attachments

postgres_fdw_pwj.patch (text/x-patch) patch

> On Mon, Mar 20, 2017 at 1:19 PM, Ashutosh Bapat
> <ashutosh.bapat@enterprisedb.com> wrote:

I have created some test to cover partition wise joins with
postgres_fdw, also verified make check.
patch attached.

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