speedup COPY TO for partitioned table

Edit
ID 5467
Title speedup COPY TO for partitioned table
CI (CFBot) Summary
Stats (from CFBot) Patch version: v20, Patch count: 1, First patch: +200−36, All patches: +200−36
Topic Server Features
Tags
Created 2024-12-27 07:18:44
Last modified 2025-10-21 05:14:54 (1 week ago)
Latest email 2025-10-20 20:06:23 (1 week ago)
Status
PG19-3 (2025-11-01 – 2025-11-30): Committed
PG19-2 (2025-09-01 – 2025-09-30): Moved to different CF
PG19-1 (2025-07-01 – 2025-07-31): Moved to different CF
2025-03 (2025-03-01 – 2025-04-08): Moved to different CF
2025-01 (2025-01-01 – 2025-01-31): Moved to different CF
Target version 19
Authors Jian He (stayreal)
Reviewers vigneshwaran C (vignesh.postgres), Kirill Reshke (reshke), Atsushi Torikoshi (atsushitorikoshi), newtglobal postgresql_contributors (newtpostgrescontributors)Become reviewer
Committer Masahiko Sawada (masahikosawada)
Links
Emails
speedup COPY TO for partitioned table.
First at 2024-12-19 12:02:20 by jian he <jian.universality at gmail.com>
Latest at 2025-10-20 20:06:23 by Masahiko Sawada <sawada.mshk at gmail.com>
Latest attachment (v20-0001-Support-COPY-TO-for-partitioned-tables.patch) at 2025-10-16 22:01:22 from Masahiko Sawada <sawada.mshk at gmail.com>
    Attachment (v20-0001-Support-COPY-TO-for-partitioned-tables.patch) at 2025-10-16 22:01:22 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v19-0001-support-COPY-partitioned_table-TO.patch) at 2025-10-16 02:56:28 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v18_masahiko_fix.patch) at 2025-10-16 01:21:10 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v18-0001-support-COPY-partitioned_table-TO.patch) at 2025-10-15 01:53:12 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v17-0001-support-COPY-partitioned_table-TO.patch) at 2025-10-10 07:10:11 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v16_fix_masahiko.patch.txt) at 2025-10-09 22:02:32 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v16-0001-support-COPY-partitioned_table-TO.patch) at 2025-10-09 07:10:16 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v15-0001-support-COPY-partitioned_table-TO.patch) at 2025-10-06 09:48:53 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v14-0001-support-COPY-partitioned_table-TO.patch) at 2025-07-15 04:16:11 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v13-0001-support-COPY-partitioned_table-TO.patch) at 2025-07-02 04:10:21 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v12-0001-support-COPY-partitioned_table-TO.patch) at 2025-06-27 07:14:38 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (copy_par_regress_test-7.sql) at 2025-06-05 00:45:10 from jian he <jian.universality at gmail.com> (Patch: No)
    Attachment (v10-0001-support-COPY-partitioned_table-TO.patch) at 2025-04-10 02:44:56 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v9-0001-support-COPY-partitioned_table-TO.patch) at 2025-04-04 03:20:07 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v8-0001-support-COPY-partitioned_table-TO.patch) at 2025-04-01 01:01:10 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v7-0001-support-COPY-partitioned_table-TO.patch) at 2025-03-30 13:53:22 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v6-0001-support-COPY-partitioned_table-TO.patch) at 2025-03-29 06:37:48 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v5-0001-support-COPY-partitioned_table-TO.patch) at 2025-03-28 03:09:15 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v4-0001-support-COPY-partitioned_table-TO.patch) at 2025-03-28 03:03:29 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v3-0001-support-COPY-partitioned_table-TO.patch) at 2025-03-11 12:53:14 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v2-0001-support-COPY-partitioned_table-TO.patch) at 2025-03-07 10:41:10 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v1-0001-speedup-COPY-TO-for-partitioned-table.patch) at 2024-12-19 12:02:20 from jian he <jian.universality at gmail.com> (Patch: Yes)
History
When Who What
2025-10-21 05:14:54 Jian He (stayreal) Closed in commitfest PG19-3 with status: Committed
2025-10-21 05:14:54 Jian He (stayreal) Changed committer to masahikosawada
2025-10-16 03:05:28 CFbot Patch does not need rebase anymore
2025-10-16 01:35:21 CFbot Patch needs rebase
2025-10-09 16:04:11 Jian He (stayreal) Moved from CF PG19-2 to CF PG19-3
2025-08-21 12:34:02 Euler Taveira (eulerto) Moved from CF PG19-1 to CF PG19-2
2025-08-19 07:02:22 Peter Eisentraut (petere) Added petere as committer
2025-07-31 06:02:02 Atsushi Torikoshi (atsushitorikoshi) New status: Needs review
2025-06-26 01:52:28 Atsushi Torikoshi (atsushitorikoshi) New status: Waiting on Author
2025-06-26 01:52:10 Atsushi Torikoshi (atsushitorikoshi) Added atsushitorikoshi as reviewer
2025-04-26 05:51:49 Jian He (stayreal) Changed targetversion to 19
2025-04-15 13:58:47 Kirill Reshke (reshke) New status: Ready for Committer
2025-04-09 12:58:54 Kirill Reshke (reshke) New status: Waiting on Author
2025-04-09 12:58:48 Kirill Reshke (reshke) Closed in commitfest 2025-03 with status: Moved to next CF
2025-04-05 16:58:49 Kirill Reshke (reshke) Added reshke as reviewer
2025-03-28 05:24:35 vigneshwaran C (vignesh.postgres) New status: Needs review
2025-03-27 09:56:20 vigneshwaran C (vignesh.postgres) New status: Waiting on Author
2025-03-25 06:39:25 vigneshwaran C (vignesh.postgres) Added vignesh.postgres as reviewer
2025-03-17 08:02:09 newtglobal postgresql_contributors (newtpostgrescontributors) Posted comment with messageid <174219852967.294107.6195385625494034792.pgcf@coridan.postgresql.org>
2025-03-17 06:11:04 newtglobal postgresql_contributors (newtpostgrescontributors) Added newtpostgrescontributors as reviewer
2025-03-07 11:01:41 CFbot Patch does not need rebase anymore
2025-03-01 20:59:32 CFbot Patch needs rebase
2025-02-27 14:15:35 Jian He (stayreal) Closed in commitfest 2025-01 with status: Moved to next CF
2025-01-15 07:53:20 Jian He (stayreal) Changed targetversion to 18
2024-12-27 07:19:40 Jian He (stayreal) Changed authors to Jian He (stayreal)
2024-12-27 07:18:44 Jian He (stayreal) Attached mail thread CACJufxEZt+G19Ors3bQUq-42-61__C=y5k2wk=sHEFRusu7=iQ@mail.gmail.com
2024-12-27 07:18:44 Jian He (stayreal) Created patch record
Edit