Re: Optimization for updating foreign tables in Postgres FDW

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Optimization for updating foreign tables in Postgres FDW
Дата
Msg-id CAB7nPqSm9VaPdk_4=VPSRGN22YzSvmfEVCjFH+2LDCk7+JACAQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Optimization for updating foreign tables in Postgres FDW  (Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>)
Ответы Re: Optimization for updating foreign tables in Postgres FDW  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-hackers
On Fri, Apr 15, 2016 at 8:25 PM, Etsuro Fujita
<fujita.etsuro@lab.ntt.co.jp> wrote:
> How about doing something similar for PQprepare/PQexecPrepared in
> postgresExecForeignInsert, postgresExecForeignUpdate, and
> postgresExecForeignDelete?

Yes, I hesitated to touch those, but they are good candidates for this
new interface, and actually it has proved not to be complicated to
plug in the new routines in those code paths.

> Also, how about doing that for PQexec in connection.c?

Here I disagree, this is not adapted. All the PQexec calls are part of
callbacks that are triggered on failures, and we rely on such a
callback when issuing PQcancel. do_sql_command runs commands that take
a short amount of time, so I think as well that it is fine as-is with
PQexec.
--
Michael

Вложения

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Parallel indicators not written by pg_get_functiondef
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Disallow unique index on system columns