Re: Join push-down support for foreign tables - Mailing list pgsql-hackers

From Etsuro Fujita
Subject Re: Join push-down support for foreign tables
Date
Msg-id 54F6CF93.4080701@lab.ntt.co.jp
Whole thread Raw
In response to Re: Join push-down support for foreign tables  (Shigeru Hanada <shigeru.hanada@gmail.com>)
List pgsql-hackers
On 2015/03/04 17:57, Shigeru Hanada wrote:
> 2015-03-04 17:00 GMT+09:00 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>:
>> On 2015/03/03 21:34, Shigeru Hanada wrote:
>>> I rebased "join push-down" patch onto Kaigai-san's Custom/Foreign Join
>>> v6 patch.

>>> but still the patch
>>> has an issue about joins underlying UPDATE or DELETE.  Now I'm working
>>> on fixing this issue.

>> Is that something like "UPDATE foo ... FROM bar ..." where both foo and bar
>> are remote?  If so, I think it'd be better to push such an update down to
>> the remote, as discussed in [2], and I'd like to work on that together!

> A part of it, perhaps.  But at the moment I see many issues to solve
> around pushing down complex UPDATE/DELETE.  So I once tightened the
> restriction, that joins between foreign tables are pushed down only if
> they are part of SELECT statement.  Please see next v4 patch I'll post
> soon.

OK, thanks for the reply!

Best regards,
Etsuro Fujita



pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: Combining Aggregates
Next
From: Shigeru Hanada
Date:
Subject: Re: Join push-down support for foreign tables