Re: Optimization for updating foreign tables in Postgres FDW

Поиск
Список
Период
Сортировка
От Etsuro Fujita
Тема Re: Optimization for updating foreign tables in Postgres FDW
Дата
Msg-id 56D57C4A.9000500@lab.ntt.co.jp
обсуждение исходный текст
Ответ на Re: Optimization for updating foreign tables in Postgres FDW  (Rushabh Lathia <rushabh.lathia@gmail.com>)
Список pgsql-hackers
On 2016/02/22 20:13, Rushabh Lathia wrote:
> PFA update patch, which includes changes into postgresPlanDMLPushdown()
> to check for join
> condition before target columns and also fixed couple of whitespace issues.

For pushing down an UPDATE/DELETE on a foreign join to the remote, I
created a WIP patch on top of the latest version of the DML pushdown
patch.  Attached is the WIP patch.  I'd like to propose this as part of
(I'd like to discuss this as a separate patch, though):

https://commitfest.postgresql.org/9/453/

The patch doesn't correctly evaluate the values of system columns of
joined relations in RETURNING, other than ctid.  I'll fix that ASAP.

Best regards,
Etsuro Fujita

Вложения

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

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: Relation extension scalability
Следующее
От: Julien Rouhaud
Дата:
Сообщение: Re: Publish autovacuum informations