Re: Foreign Join pushdowns not working properly for outer joins

From: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
To: Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>, David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>
Cc: Etsuro Fujita <fujita(dot)etsuro(at)lab(dot)ntt(dot)co(dot)jp>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Foreign Join pushdowns not working properly for outer joins
Date: 2017-04-25 14:12:27
Message-ID: 44f9ddb3-ff76-830b-dfb5-c7bfe1b8e3c3@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 4/24/17 22:50, Peter Eisentraut wrote:
> On 4/14/17 00:24, Ashutosh Bapat wrote:
>> This looks better. Here are patches for master and 9.6.
>> Since join pushdown was supported in 9.6 the patch should be
>> backported to 9.6 as well. Attached is the patch (_96) for 9.6,
>> created by rebasing on 9.6 branch and removing conflict. _v6 is
>> applicable on master.
>
> Committed to PG10. I'll work on backpatching next.

For backpatching to 9.6, I came up with the attached reduced version.
Since we don't have add_foreign_grouping_paths() in 9.6, we can omit the
refactoring and keep the changes much simpler. Does that make sense?

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Attachment Content-Type Size
0001-postgres_fdw-Fix-join-push-down-with-extensions.patch invalid/octet-stream 5.9 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2017-04-25 14:15:12 Re: PG 10 release notes
Previous Message Bruce Momjian 2017-04-25 14:10:07 Re: PG 10 release notes