Re: Foreign join pushdown vs EvalPlanQual - Mailing list pgsql-hackers

From Etsuro Fujita
Subject Re: Foreign join pushdown vs EvalPlanQual
Date
Msg-id 5639D6E6.6070102@lab.ntt.co.jp
Whole thread Raw
In response to Re: Foreign join pushdown vs EvalPlanQual  (Kouhei Kaigai <kaigai@ak.jp.nec.com>)
List pgsql-hackers
On 2015/11/04 17:28, Kouhei Kaigai wrote:
>> I think we need to consider a general solution that can be applied not
>> only to the case where the component tables in a foreign join all use
>> ROW_MARK_COPY but to the case where those tables use different rowmark
>> types such as ROW_MARK_COPY and ROW_MARK_EXCLUSIVE, as I pointed out
>> upthread.

> In mixture case, FDW/CSP can choose local recheck & reconstruction based
> on the EPQ tuples of base relation. Nobody enforce FDW/CSP to return
> a joined tuple always even if author don't want to support the feature.
> Why do you think it is not a generic solution? FDW/CSP driver "can choose"
> the best solution according to its implementation and capability.

It looked to me that you were discussing only the case where component 
foreign tables in a foreign join all use ROW_MARK_COPY, so I commented 
that.  Sorry for my misunderstanding.

Best regards,
Etsuro Fujita




pgsql-hackers by date:

Previous
From: Etsuro Fujita
Date:
Subject: Re: Foreign join pushdown vs EvalPlanQual
Next
From: Andres Freund
Date:
Subject: Re: Re: BUG #13685: Archiving while idle every archive_timeout with wal_level hot_standby