Re: Foreign join pushdown vs EvalPlanQual

Поиск
Список
Период
Сортировка
От Etsuro Fujita
Тема Re: Foreign join pushdown vs EvalPlanQual
Дата
Msg-id 56446AFD.2050208@lab.ntt.co.jp
обсуждение исходный текст
Ответ на Re: Foreign join pushdown vs EvalPlanQual  (Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>)
Список pgsql-hackers
Horiguchi-san,

On 2015/11/12 16:10, Kyotaro HORIGUCHI wrote:
>>> I really don't see why you're fighting on this point.  Making this a
>>> generic feature will require only a few extra lines of code for FDW
>>> authors.  If this were going to cause some great inconvenience for FDW
>>> authors, then I'd agree it isn't worth it.  But I see zero evidence
>>> that this is actually the case.

>> Really?  I think there would be not a little burden on an FDW author;
>> when postgres_fdw delegates to the subplan to the remote server, for
>> example, it would need to create a remote join query by looking at
>> tuples possibly fetched and stored in estate->es_epqTuple[], send the
>> query and receive the result during the callback routine.

> Do you mind that FDW cannot generate a plan so that make a tuple
> from eqpTules then apply fdw_quals from predefined executor
> nodes?

No.  Please see my previous email.  Sorry for my unfinished email.

Best regards,
Etsuro Fujita




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Etsuro Fujita
Дата:
Сообщение: Re: Minor comment improvement to create_foreignscan_plan
Следующее
От: Alexander Korotkov
Дата:
Сообщение: Re: WIP: Rework access method interface