Horton

Re: POC: postgres_fdw insert batching

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Cc: "'Tomas Vondra'" <tomas.vondra@enterprisedb.com>, Amit Langote <amitlangote09@gmail.com>, Zhihong Yu <zyu@yugabyte.com>, "Andrey V. Lepikhov" <a.lepikhov@postgrespro.ru>, Tomas Vondra <tomas.vondra@2ndquadrant.com>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2021-01-21T02:03:46Z
Lists: pgsql-hackers 
"tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com> writes:
> Just for learning, could anyone tell me what this loop for?  I thought current Postgres's DML supports a single target table, so it's enough to handle the first element of mtstate->resultRelInfo.

The "single target table" could be partitioned, in which case there'll be
multiple resultrelinfos, some of which could be foreign tables.

			regards, tom lane

Commits

  1. Fix tuple routing to initialize batching only for inserts

  2. Fix pointer type in ExecForeignBatchInsert SGML docs

  3. Fix initialization of FDW batching in ExecInitModifyTable

  4. Implement support for bulk inserts in postgres_fdw