Re: Optimization for updating foreign tables in Postgres FDW - Mailing list pgsql-hackers

From Etsuro Fujita
Subject Re: Optimization for updating foreign tables in Postgres FDW
Date
Msg-id 56D57C4A.9000500@lab.ntt.co.jp
Whole thread Raw
In response to Re: Optimization for updating foreign tables in Postgres FDW  (Rushabh Lathia <rushabh.lathia@gmail.com>)
List 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

Attachment

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Relation extension scalability
Next
From: Julien Rouhaud
Date:
Subject: Re: Publish autovacuum informations