Re: Push down more full joins in postgres_fdw - Mailing list pgsql-hackers

From Etsuro Fujita
Subject Re: Push down more full joins in postgres_fdw
Date
Msg-id 5987f190-721c-190c-68be-f14d53c8478a@lab.ntt.co.jp
Whole thread Raw
In response to Re: Push down more full joins in postgres_fdw  (Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>)
List pgsql-hackers
On 2016/09/09 21:35, Etsuro Fujita wrote:
> On 2016/09/08 19:51, Etsuro Fujita wrote:
>> On 2016/09/06 22:07, Ashutosh Bapat wrote:
>>> This patch tries to do two things at a time 1. support join pushdown for
>>> FULL join when the joining relations have remote conditions 2. better
>>> support for fetching placeholder vars, whole row references and some
>>> system columns. To make reviews easy, I think we should split the patch
>>> into two 1. supporting subqueries to be deparsed with support for one of
>>> the above (I will suggest FULL join support) 2. support for the other.

>> OK, will try.

> I extracted #1 from the patch.  Attached is a patch for that.  If that
> patch is reasonable, I'll create a patch for #2 on top of it.

Attached is a patch for #2.  In that patch I fixed some bugs and added a
bit more comments.  For testing, please apply the patch for #1 first.

Best regards,
Etsuro Fujita

Attachment

pgsql-hackers by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: [REVIEW] Tab Completion for CREATE DATABASE ... TEMPLATE ...
Next
From: Michael Paquier
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Use LEFT JOINs in some system views in case referenced row doesn