| 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-12 12:35:35 |
| Message-ID: | 5987f190-721c-190c-68be-f14d53c8478a@lab.ntt.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 | Content-Type | Size |
|---|---|---|
| postgres-fdw-phv-pushdown-v1.patch | binary/octet-stream | 65.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2016-09-12 12:53:05 | Re: Re: [COMMITTERS] pgsql: Use LEFT JOINs in some system views in case referenced row doesn |
| Previous Message | Kevin Grittner | 2016-09-12 12:29:48 | Re: [REVIEW] Tab Completion for CREATE DATABASE ... TEMPLATE ... |