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

From: Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>
To: Rafia Sabih <rafia(dot)sabih(at)enterprisedb(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>, Rajkumar Raghuwanshi <rajkumar(dot)raghuwanshi(at)enterprisedb(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Partition-wise join for join between (declaratively) partitioned tables
Date: 2017-07-10 10:27:48
Message-ID: CAFjFpRfcMhxHOejTULfRcc_8WD=jzde9Z6E+vZ0B8MEZugw58w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Jul 4, 2017 at 10:02 AM, Ashutosh Bapat
<ashutosh(dot)bapat(at)enterprisedb(dot)com> wrote:
> On Fri, Jun 30, 2017 at 2:53 PM, Rafia Sabih
> <rafia(dot)sabih(at)enterprisedb(dot)com> wrote:
>>
>>
>> On Mon, May 22, 2017 at 12:02 PM, Ashutosh Bapat
>> <ashutosh(dot)bapat(at)enterprisedb(dot)com> wrote:
>>>
>>>
>>> Here's set of patches rebased on latest head.
>>
>>
>> In an attempt to test this set of patches, I found that not all of the
>> patches could be applied on latest head-- commit
>> 08aed6604de2e6a9f4d499818d7c641cbf5eb9f7
>> Might be in need of rebasing.
>
> Thanks Rafia for your interest. I have started rebasing the patches on
> the latest head. I am expecting it to take some time. Will update the
> thread with the patches once I am done rebasing them.
>

Here are patches rebased.

As mentioned in my previous mail [1], the last two patches are not
complete but are included, so that the reviewer can see the changes we
will have to make when we go towards more general partition-wise join.
Please use patches upto 0015, which implement 1:1 partition mapping
for benchmarking and testing.

[1] https://www.postgresql.org/message-id/CAFjFpRdF8GpmSjjn0fm85cMW2iz+r3MQJQ_HC0eDATzWSv5buw@mail.gmail.com

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

Attachment Content-Type Size
pg_dp_join_patches_v21.tar.gz application/x-gzip 151.8 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Gierth 2017-07-10 10:45:25 Re: COPY vs. transition tables
Previous Message Masahiko Sawada 2017-07-10 10:27:40 Re: [COMMITTERS] pgsql: Allow multiple hostaddrs to go with multiple hostnames.