Re: Asymmetric partition-wise JOIN

From: "Andrey V(dot) Lepikhov" <a(dot)lepikhov(at)postgrespro(dot)ru>
To: Daniel Gustafsson <daniel(at)yesql(dot)se>, Kohei KaiGai <kaigai(at)heterodb(dot)com>
Cc: Michael Paquier <michael(at)paquier(dot)xyz>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Asymmetric partition-wise JOIN
Date: 2020-08-21 06:02:30
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On 7/1/20 2:10 PM, Daniel Gustafsson wrote:
>> On 27 Dec 2019, at 08:34, Kohei KaiGai <kaigai(at)heterodb(dot)com> wrote:
>> The attached v2 fixed the problem, and regression test finished correctly.
> This patch no longer applies to HEAD, please submit an rebased version.
> Marking the entry Waiting on Author in the meantime.
Rebased version of the patch on current master (d259afa736).

I rebased it because it is a base of my experimental feature than we
don't break partitionwise join of a relation with foreign partition and
a local relation if we have info that remote server has foreign table
link to the local relation (by analogy with shippable extensions).

Maybe mark as 'Needs review'?

Andrey Lepikhov
Postgres Professional

Attachment Content-Type Size
pgsql13-asymmetric-partitionwise-join.v3.patch text/x-patch 22.0 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Masahiko Sawada 2020-08-21 06:16:44 Re: Fix typo in procarrary.c
Previous Message Pierre Giraud 2020-08-21 05:54:13 Re: [PG13] Planning (time + buffers) data structure in explain plan (format text)