Re: Push down more full joins in postgres_fdw

From: Etsuro Fujita <fujita(dot)etsuro(at)lab(dot)ntt(dot)co(dot)jp>
To: Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Push down more full joins in postgres_fdw
Date: 2016-09-09 12:35:45
Message-ID: c7fa625b-ab02-bec0-275e-9b35b4d8c816@lab.ntt.co.jp
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-hackers

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.

Comments welcome!

Best regards,
Etsuro Fujita

Attachment Content-Type Size
postgres-fdw-more-full-join-pushdown-v3.patch binary/octet-stream 82.3 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2016-09-09 12:45:54 Re: ICU integration
Previous Message Greg Stark 2016-09-09 12:25:29 Re: Tuplesort merge pre-reading