Re: Fast COPY FROM based on batch insert

Andrei Lepikhov <a.lepikhov@postgrespro.ru>

From: Andrey Lepikhov <a.lepikhov@postgrespro.ru>

To: "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>

Cc: Etsuro Fujita <etsuro.fujita@gmail.com>, Justin Pryzby <pryzby@telsasoft.com>, Zhihong Yu <zyu@yugabyte.com>, Amit Langote <amitlangote09@gmail.com>, "tanghy.fnst@fujitsu.com" <tanghy.fnst@fujitsu.com>, Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>, Pg Hackers <pgsql-hackers@postgresql.org>, Tomas Vondra <tomas.vondra@enterprisedb.com>, "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>

Date: 2021-06-07T11:16:58Z

Lists: pgsql-hackers

Attachments

v2-0001-Implementation-of-a-Bulk-COPY-FROM.patch (text/plain) patch v2-0001

Second version of the patch fixes problems detected by the FDW 
regression tests and shows differences of error reports in 
tuple-by-tuple and batched COPY approaches.

-- 
regards,
Andrey Lepikhov
Postgres Professional

Commits

Allow batch insertion during COPY into a foreign table.
- 97da48246d34 16.0 landed
postgres_fdw: Disable batch insertion when there are WCO constraints.
- 82593b9a3d5f 16.0 cited
Enforce foreign key correctly during cross-partition updates
- ba9a7e392171 15.0 cited
Fix permission checks on constraint violation errors on partitions.
- 6214e2b22804 14.0 cited
Fix compilation of uuid-ossp
- 525e60b74299 14.0 cited