Re: postgres_fdw: Use COPY to speed up batch inserts

Matheus Alcantara <matheusssilv97@gmail.com>

From: "Matheus Alcantara" <matheusssilv97@gmail.com>

To: "Masahiko Sawada" <sawada.mshk@gmail.com>

Cc: "Andrew Dunstan" <andrew@dunslane.net>, "jian he" <jian.universality@gmail.com>, "Tomas Vondra" <tomas@vondra.me>, <pgsql-hackers@postgresql.org>

Date: 2025-12-11T12:03:23Z

Lists: pgsql-hackers

Attachments

v8-0001-postgres_fdw-speed-up-batch-inserts-using-COPY.patch (text/plain)

I've spent some more time on this patch cleaning up some things and
trying to simplify some things.

I've renamed "copy_for_batch_insert_threshold" to
"batch_with_copy_threshold" and removed the boolean option
"use_copy_for_batch_insert", so now to enable the COPY usage for batch
inserts it only need to set batch_with_copy_threshold to a number
greater than 0.

Also the COPY can only be used if batching is also enabled (batch_size >
1) and it will only be used for the COPY FROM on a foreign table and for
inserts into table partitions that are also foreign tables.

--
Matheus Alcantara
EDB: http://www.enterprisedb.com