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

From Albe Laurenz
Subject Re: Optimization for updating foreign tables in Postgres FDW
Date
Msg-id A737B7A37273E048B164557ADEF4A58B365A2C3A@ntex2010i.host.magwien.gv.at
Whole thread Raw
In response to Re: Optimization for updating foreign tables in Postgres FDW  (Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>)
Responses Re: Optimization for updating foreign tables in Postgres FDW  (Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>)
List pgsql-hackers
Etsuro Fujita wrote:
> While updating the patch, I noticed that in the previous patch, there is
> a bug in pushing down parameterized UPDATE/DELETE queries; generic plans
> for such queries fail with a can't-happen error.  I fixed the bug and
> tried to add the regression tests that execute the generic plans, but I
> couldn't because I can't figure out how to force generic plans.  Is
> there any way to do that?

I don't know about a way to force it, but if you run the statement six
times, it will probably switch to a generic plan.

Yours,
Laurenz Albe

pgsql-hackers by date:

Previous
From: Etsuro Fujita
Date:
Subject: Re: Optimization for updating foreign tables in Postgres FDW
Next
From: Etsuro Fujita
Date:
Subject: Re: Join push-down support for foreign tables