RE: POC: postgres_fdw insert batching

Поиск
Список
Период
Сортировка
От tsunakawa.takay@fujitsu.com
Тема RE: POC: postgres_fdw insert batching
Дата
Msg-id TYAPR01MB2990E3D10A122358419482B2FEBD0@TYAPR01MB2990.jpnprd01.prod.outlook.com
обсуждение исходный текст
Ответ на Re: POC: postgres_fdw insert batching  (Amit Langote <amitlangote09@gmail.com>)
Ответы Re: POC: postgres_fdw insert batching  (Amit Langote <amitlangote09@gmail.com>)
Список pgsql-hackers
From: Amit Langote <amitlangote09@gmail.com>
> Yes, it can be simplified by using a local join to prevent the update of the foreign
> partition from being pushed to the remote server, for which my example in the
> previous email used a local trigger.  Note that the update of the foreign
> partition to be done locally is a prerequisite for this bug to occur.

Thank you, I was aware that UPDATE calls ExecInsert() but forgot about it partway.  Good catch (and my bad miss.)


+    PgFdwModifyState *fmstate = resultRelInfo->ri_FdwState ?
+                            (PgFdwModifyState *) resultRelInfo->ri_FdwState :
+                            NULL;

This can be written as:

+    PgFdwModifyState *fmstate = (PgFdwModifyState *) resultRelInfo->ri_FdwState;


Regards
Takayuki Tsunakawa


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

Предыдущее
От: Masahiro Ikeda
Дата:
Сообщение: Re: About to add WAL write/fsync statistics to pg_stat_wal view
Следующее
От: Masahiro Ikeda
Дата:
Сообщение: Re: About to add WAL write/fsync statistics to pg_stat_wal view