postgres_fdw: Use COPY to speed up batch inserts

Edit
ID 6137
Title postgres_fdw: Use COPY to speed up batch inserts
CI (CFBot) Summary
Stats (from CFBot) Patch version: v7, Patch count: 1, First patch: +304−3, All patches: +304−3
Topic Performance
Tags
Created 2025-10-16 21:09:40
Last modified 2025-12-03 13:10:31 (57 minutes ago)
Latest email 2025-11-26 20:51:36 (6 days ago)
Status
PG19-4 (2026-01-01 – 2026-01-31): Needs review
PG19-3 (2025-11-01 – 2025-11-30): Moved to different CF
Target version
Authors Matheus Alcantara (matheus.alcantara)
Reviewers Become reviewer
Committer
Links
Emails
postgres_fdw: Use COPY to speed up batch inserts
First at 2025-10-15 15:02:01 by "Matheus Alcantara" <matheusssilv97 at gmail.com>
Latest at 2025-11-26 20:51:36 by "Matheus Alcantara" <matheusssilv97 at gmail.com>
Latest attachment (v7-0001-postgres_fdw-speed-up-batch-inserts-using-COPY.patch) at 2025-11-26 20:51:36 from "Matheus Alcantara" <matheusssilv97 at gmail.com>
    Attachment (v7-0001-postgres_fdw-speed-up-batch-inserts-using-COPY.patch) at 2025-11-26 20:51:36 from "Matheus Alcantara" <matheusssilv97 at gmail.com> (Patch: Yes)
    Attachment (v6-0001-postgres_fdw-Enable-the-use-of-COPY-to-speed-up-i.patch) at 2025-11-18 22:13:17 from "Matheus Alcantara" <matheusssilv97 at gmail.com> (Patch: Yes)
    Attachment (v5-0001-postgres_fdw-Enable-the-use-of-COPY-to-speed-up-i.patch) at 2025-11-06 23:49:37 from "Matheus Alcantara" <matheusssilv97 at gmail.com> (Patch: Yes)
    Attachment (fdw_copy_test.sql) at 2025-10-29 03:10:55 from jian he <jian.universality at gmail.com> (Patch: No)
    Attachment (v4-0001-postgres_fdw-Use-COPY-to-speed-up-batch-inserts.patch) at 2025-10-24 18:27:01 from "Matheus Alcantara" <matheusssilv97 at gmail.com> (Patch: Yes)
    Attachment (v3-0001-postgres_fdw-Use-COPY-to-speed-up-batch-inserts.patch) at 2025-10-23 00:00:46 from "Matheus Alcantara" <matheusssilv97 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-postgres_fdw-Use-COPY-to-speed-up-batch-inserts.patch) at 2025-10-21 14:25:19 from Matheus Alcantara <matheusssilv97 at gmail.com> (Patch: Yes)
    Attachment (fdw-copy-results.pdf) at 2025-10-16 20:39:47 from Tomas Vondra <tomas at vondra.me> (Patch: No)
    Attachment (v1-0001-postgres_fdw-Use-COPY-to-speed-up-batch-inserts.patch) at 2025-10-15 15:02:01 from "Matheus Alcantara" <matheusssilv97 at gmail.com> (Patch: Yes)
History
When Who What
2025-12-03 13:10:31 Matheus Alcantara (matheus.alcantara) Moved from CF PG19-3 to CF PG19-4
2025-10-16 21:09:41 Matheus Alcantara (matheus.alcantara) Attached mail thread DDIZJ217OUDK.2R5WE4OGL5PTY@gmail.com
2025-10-16 21:09:40 Matheus Alcantara (matheus.alcantara) Created patch record
Edit