RE: [POC] Fast COPY FROM command for the table with foreign partitions

tsunakawa.takay@fujitsu.com <tsunakawa.takay@fujitsu.com>

View thread View on postgr.es

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

To: 'Justin Pryzby' <pryzby@telsasoft.com>

Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2021-03-12T05:54:29Z

Lists: pgsql-hackers

Attachments

v20-0001-Fast-COPY-FROM-into-the-foreign-or-sharded-table.patch (application/octet-stream) patch v20-0001

From: Justin Pryzby <pryzby@telsasoft.com>
> Could you rebase again and send an updated patch ?
> I could do it if you want.

Rebased and attached.  Fortunately, there was no rebase conflict this time.  make check passed for PG core and postgres_fdw.

	
Regards
Takayuki Tsunakawa

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