Based on the discussion at:
https://www.postgresql.org/message-id/6929d485-2d2a-da46-3681-4a400a3d794f%40enterprisedb.com
I'm posting the patch for $subject here in this new thread and I'll
add it to the next CF per Tomas' advice.
With 927f453a94106 committed earlier today, we limit insert batching
only to the cases where the query's main command is also insert,
because allowing it to be used in other cases can hit some limitations
of the current code.
One such case is cross-partition updates of a partitioned table which
internally uses insert. postgres_fdw supports some cases where a row
is moved from a local partition to a foreign partition. When doing
so, the moved row is inserted into the latter, but those inserts can't
use batching due to the aforementioned commit.
As described in the thread linked above, to make batching possible for
those internal inserts, we'd need to make some changes to both the
core code and postgres_fdw, which the attached patch implements.
Details are in the commit message.
--
Amit Langote
EDB: http://www.enterprisedb.com
