speedup COPY TO for partitioned table

Edit

5467

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v14, Patch count: 1, First patch: +171−34, All patches: +171−34

Topic

Server Features

Tags

Created

2024-12-27 07:18:44

Last modified

2025-07-31 06:02:02 (2 weeks ago)

Latest email

2025-07-30 03:21:55 (2 weeks ago)

Status

PG19-1 (2025-07-01 - 2025-07-31): Needs review

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

Authors

Jian He (stayreal)

Reviewers

vigneshwaran C (vignesh.postgres), Kirill Reshke (reshke), Atsushi Torikoshi (atsushitorikoshi), newtglobal postgresql_contributors (newtpostgrescontributors)Become reviewer

Committer

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-07-30 03:21:55 by jian he <jian.universality at gmail.com>
Latest attachment (v14-0001-support-COPY-partitioned_table-TO.patch) at 2025-07-15 04:16:11 from jian he <jian.universality at gmail.com>
    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-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