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 54F6BD46.3000003@lab.ntt.co.jp
Whole thread Raw
In response to Re: Optimization for updating foreign tables in Postgres FDW  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Responses Re: Optimization for updating foreign tables in Postgres FDW  (Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>)
List pgsql-hackers
On 2015/03/04 16:58, Albe Laurenz wrote:
> 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.

Yeah, I was just thinking running the statement six times in the 
regression tests ...

Thanks!

Best regards,
Etsuro Fujita



pgsql-hackers by date:

Previous
From: Kyotaro HORIGUCHI
Date:
Subject: Re: Reduce pinning in btree indexes
Next
From: Fabien COELHO
Date:
Subject: Re: add modulo (%) operator to pgbench