Re: Optimization for updating foreign tables in Postgres FDW

Поиск
Список
Период
Сортировка
От Etsuro Fujita
Тема Re: Optimization for updating foreign tables in Postgres FDW
Дата
Msg-id 54F6BD46.3000003@lab.ntt.co.jp
обсуждение исходный текст
Ответ на Re: Optimization for updating foreign tables in Postgres FDW  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Ответы Re: Optimization for updating foreign tables in Postgres FDW  (Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>)
Список 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 по дате отправления:

Предыдущее
От: Kyotaro HORIGUCHI
Дата:
Сообщение: Re: Reduce pinning in btree indexes
Следующее
От: Fabien COELHO
Дата:
Сообщение: Re: add modulo (%) operator to pgbench