postgres_fdw: Use COPY to speed up batch inserts

Edit
ID 6137
Title postgres_fdw: Use COPY to speed up batch inserts
CI (CFBot) Needs rebase! Needs rebase since 3 weeks. Failing since 3 weeks.
Additional links previous successfully applied patch (outdated):
Stats (from CFBot) Unknown
Tags Performance
Created 2025-10-16 21:09:40
Last modified 2026-10-01 09:37:39 (57 minutes ago)
Latest email 2026-09-09 20:16:16 (3 weeks ago)
Status
PG20-3 (2026-11-01 – 2026-11-30): Needs review
PG20-2 (2026-09-01 – 2026-09-30): Moved to different CF
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-09-09 20:16:16 by Kirill Reshke <reshkekirill at gmail.com>
Latest attachment (v16_plus_cached_full_diff.patch) at 2026-09-09 20:10:37 from Kirill Reshke <reshkekirill at gmail.com>
    Attachment (v16_plus_cached_full_diff.patch) at 2026-09-09 20:10:37 from Kirill Reshke <reshkekirill at gmail.com> (Patch: Yes)
    Attachment (v16-0003-postgres_fdw-use-COPY-to-bulk-load-foreign-table.patch) at 2026-08-05 21:33:15 from Matheus Alcantara <matheusssilv97 at gmail.com> (Patch: No)
    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-10-01 09:37:39 Matheus Alcantara (matheus.alcantara) Moved from CF PG20-2 to CF PG20-3
2026-09-09 20:44:27 CFbot Patch needs rebase
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