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: v5, Patch count: 2, First patch: +452−15, All patches: +455−15
Topic Performance
Tags
Created 2025-10-16 21:09:40
Last modified 2025-10-16 21:09:41 (4 weeks ago)
Latest email 2025-11-06 23:49:37 (1 week ago)
Status
PG19-3 (2025-11-01 – 2025-11-30): Needs review
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-06 23:49:37 by "Matheus Alcantara" <matheusssilv97 at gmail.com>
Latest 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>
    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-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