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: v15, Patch count: 2, First patch: +71−20, All patches: +478−29
Tags Performance
Created 2025-10-16 21:09:40
Last modified 2026-08-03 12:38:23 (1 hour ago)
Latest email 2026-05-27 23:25:12 (2 months ago)
Status
PG20-2 (2026-09-01 – 2026-09-30): Needs review
PG20-1 (2026-07-01 – 2026-07-31): Moved to different CF
PG19-Final (2026-03-01 – 2026-04-09): Moved to different CF
PG19-4 (2026-01-01 – 2026-01-31): Moved to different CF
PG19-3 (2025-11-01 – 2025-11-30): Moved to different CF
Target version
Authors Matheus Alcantara (matheus.alcantara)
Reviewers Masahiko Sawada (masahikosawada), solai v (solaiv) 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 2026-05-27 23:25:12 by Matheus Alcantara <matheusssilv97 at gmail.com>
Latest attachment (v15-0001-Extract-CopyEscapeText-for-reuse-outside-COPY-TO.patch) at 2026-05-27 23:22:47 from "Matheus Alcantara" <matheusssilv97 at gmail.com>
    Attachment (v15-0001-Extract-CopyEscapeText-for-reuse-outside-COPY-TO.patch) at 2026-05-27 23:22:47 from "Matheus Alcantara" <matheusssilv97 at gmail.com> (Patch: Yes)
    Attachment (v14-0001-postgres_fdw-Use-COPY-as-remote-SQL-when-possibl.patch) at 2026-04-07 21:00:56 from "Matheus Alcantara" <matheusssilv97 at gmail.com> (Patch: Yes)
    Attachment (v13-0001-postgres_fdw-Use-COPY-as-remote-SQL-when-possibl.patch) at 2026-04-01 15:50:14 from "Matheus Alcantara" <matheusssilv97 at gmail.com> (Patch: Yes)
    Attachment (v12-0001-postgres_fdw-Use-COPY-as-remote-SQL-when-possibl.patch) at 2026-03-04 12:17:21 from Matheus Alcantara <matheusssilv97 at gmail.com> (Patch: Yes)
    Attachment (v11-0001-postgres_fdw-Use-COPY-as-remote-SQL-when-possibl.patch) at 2026-02-26 15:58:21 from "Matheus Alcantara" <matheusssilv97 at gmail.com> (Patch: Yes)
    Attachment (v10-0001-postgres_fdw-Use-COPY-as-remote-SQL-when-possibl.patch) at 2026-01-29 14:02:45 from "Matheus Alcantara" <matheusssilv97 at gmail.com> (Patch: Yes)
    Attachment (v9-0001-postgres_fdw-speed-up-batch-inserts-using-COPY.patch) at 2026-01-05 13:43:52 from "Matheus Alcantara" <matheusssilv97 at gmail.com> (Patch: Yes)
    Attachment (v8-0001-postgres_fdw-speed-up-batch-inserts-using-COPY.patch) at 2025-12-11 12:03:23 from "Matheus Alcantara" <matheusssilv97 at gmail.com> (Patch: Yes)
    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
2026-08-03 12:38:23 Matheus Alcantara (matheus.alcantara) Moved from CF PG20-1 to CF PG20-2
2026-05-21 04:32:29 solai v (solaiv) Added solaiv as reviewer
2026-04-10 00:00:03 CFbot Moved from CF PG19-Final to CF PG20-1
2026-02-01 00:00:09 CFbot Moved from CF PG19-4 to CF PG19-Final
2026-01-30 22:45:33 Masahiko Sawada (masahikosawada) Added masahikosawada as reviewer
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