pg_dump flag for dumping tables data in multiple chunks, for huge tables can often give near-linear speedup when parallelized

Edit
ID 6219
Title pg_dump flag for dumping tables data in multiple chunks, for huge tables can often give near-linear speedup when parallelized
CI (CFBot) Summary
Stats (from CFBot) Patch version: v17, Patch count: 1, First patch: +420−64, All patches: +420−64
Tags libpq Performance
Created 2025-11-13 20:32:23
Last modified 2026-10-01 19:58:08 (1 hour ago)
Latest email 2026-08-06 12:56:47 (1 month 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
Target version stable
Authors Hannu Krosing (hannukrosing)
Reviewers Dilip Kumar (dilip.kumar), Pavel Stehule (okbobcz), Neil Min (neilmin) Become reviewer
Committer
Links
Emails
Patch: dumping tables data in multiple chunks in pg_dump
First at 2025-11-11 15:29:56 by Hannu Krosing <hannuk at google.com>
Latest at 2026-08-06 12:56:47 by Hannu Krosing <hannuk at google.com>
Latest attachment (v17--0001-Add-max-table-segment-pages-option-to-pg_dump-fo.patch) at 2026-08-06 12:56:47 from Hannu Krosing <hannuk at google.com>
    Attachment (v17--0001-Add-max-table-segment-pages-option-to-pg_dump-fo.patch) at 2026-08-06 12:56:47 from Hannu Krosing <hannuk at google.com> (Patch: No)
    Attachment (v16-0001-Add-max-table-segment-pages-option-to-pg_dump-fo.patch) at 2026-03-30 17:32:34 from Hannu Krosing <hannuk at google.com> (Patch: Yes)
    Attachment (v15-0001-Add-max-table-segment-pages-option-to-pg.patch) at 2026-03-29 21:49:38 from Hannu Krosing <hannuk at google.com> (Patch: Yes)
    Attachment (v14-0001-SUBJECT-Add-max-table-segment-pages-option-to-pg.patch) at 2026-03-28 10:59:18 from Hannu Krosing <hannuk at google.com> (Patch: Yes)
    Attachment (v13-0001-changed-flag-name-to-max-table-segment-pages.patch) at 2026-01-28 17:29:58 from Hannu Krosing <hannuk at google.com> (Patch: Yes)
    Attachment (v12-0001-changed-flag-name-to-max-table-segment-pages.patch) at 2026-01-27 22:43:44 from Hannu Krosing <hannuk at google.com> (Patch: Yes)
    Attachment (v10-0001-changed-flag-name-to-max-table-segment-pages.patch) at 2026-01-22 17:05:04 from Hannu Krosing <hannuk at google.com> (Patch: Yes)
    Attachment (v9-0001-changed-flag-name-to-max-table-segment-pages.patch) at 2026-01-21 13:05:46 from Hannu Krosing <hannuk at google.com> (Patch: Yes)
    Attachment (v8-0001-changed-flag-name-to-max-table-segment-pages.patch) at 2026-01-19 23:07:56 from Hannu Krosing <hannuk at google.com> (Patch: Yes)
    Attachment (v7-0001-changed-flag-name-to-max-table-segment-pages.patch) at 2026-01-19 19:01:29 from Hannu Krosing <hannuk at google.com> (Patch: Yes)
    Attachment (0001-adds-ability-to-dump-data-for-tables-in-multiple-chu.patch) at 2025-11-11 15:29:56 from Hannu Krosing <hannuk at google.com> (Patch: Yes)
History
When Who What
2026-10-01 19:58:08 Hannu Krosing (hannukrosing) Moved from CF PG20-2 to CF PG20-3
2026-08-06 13:17:40 CFbot Patch does not need rebase anymore
2026-08-06 12:58:09 Hannu Krosing (hannukrosing) New status: Needs review
2026-08-06 12:57:47 Hannu Krosing (hannukrosing) Moved from CF PG20-1 to CF PG20-2
2026-04-05 17:06:26 CFbot Patch needs rebase
2026-04-01 09:45:32 Hannu Krosing (hannukrosing) Moved from CF PG19-Final to CF PG20-1
2026-03-28 11:07:31 CFbot Patch does not need rebase anymore
2026-02-17 06:00:29 CFbot Patch needs rebase
2026-02-12 04:55:18 Dilip Kumar (dilip.kumar) Added dilip.kumar as reviewer
2026-02-01 00:00:08 CFbot Moved from CF PG19-4 to CF PG19-Final
2026-01-15 18:15:00 Neil Min (neilmin) Added neilmin as reviewer
2026-01-13 12:57:59 Hannu Krosing (hannukrosing) Changed tags to Performance
2026-01-13 02:30:32 David Rowley (davidrowley) New status: Waiting on Author
2026-01-11 11:19:46 Hannu Krosing (hannukrosing) Changed tags to Backport, Performance
2026-01-11 09:13:20 Hannu Krosing (hannukrosing) Changed tags to Performance
2025-12-12 07:22:25 Pavel Stehule (okbobcz) Added okbobcz as reviewer
2025-11-13 20:33:17 Hannu Krosing (hannukrosing) Changed name to pg_dump flag for dumping tables data in multiple chunks, for huge tables can often give near-linear speedup when parallelized
2025-11-13 20:32:23 Hannu Krosing (hannukrosing) Attached mail thread CAMT0RQT_0qVxcTT6ycM20QUN-pEQ6iMLbz6gLWgLpeF0NmNOUA@mail.gmail.com
2025-11-13 20:32:23 Hannu Krosing (hannukrosing) Created patch record
Edit