parallel pg_restore: avoid disk seeks when jumping short distance forward

Edit
ID 5809
Title parallel pg_restore: avoid disk seeks when jumping short distance forward
CI (CFBot) Summary
Stats (from CFBot) Patch version: v5, Patch count: 1, First patch: +5−1, All patches: +5−1
Topic Performance
Tags
Created 2025-06-09 20:01:41
Last modified 2025-10-21 21:29:12 (1 week ago)
Latest email 2025-10-21 17:36:53 (1 week ago)
Status
PG19-3 (2025-11-01 – 2025-11-30): Committed
PG19-1 (2025-07-01 – 2025-07-31): Moved to different CF
Target version 19
Authors Dimitrios Apostolou (jimis)
Reviewers Tom Lane (tgl)Become reviewer
Committer Tom Lane (tgl)
Links
Emails
[PATCH v1] parallel pg_restore: avoid disk seeks when jumping short distance forward
First at 2025-03-29 00:46:30 by Dimitrios Apostolou <jimis at gmx.net>
Latest at 2025-10-21 17:36:53 by Tom Lane <tgl at sss.pgh.pa.us>
Latest attachment (v5-0001-parallel-pg_restore-avoid-disk-seeks-when-moving-.patch) at 2025-10-21 14:16:26 from Dimitrios Apostolou <jimis at gmx.net>
    Attachment (v5-0001-parallel-pg_restore-avoid-disk-seeks-when-moving-.patch) at 2025-10-21 14:16:26 from Dimitrios Apostolou <jimis at gmx.net> (Patch: Yes)
    Attachment (v1-0001-WIP-increase-glibc-buffering-for-pg_restore-custo.patch) at 2025-10-21 13:57:31 from Dimitrios Apostolou <jimis at gmx.net> (Patch: Yes)
    Attachment (v4-0001-parallel-pg_restore-avoid-disk-seeks-when-moving-.patch) at 2025-10-20 18:40:27 from Dimitrios Apostolou <jimis at gmx.net> (Patch: Yes)
    Attachment (v5-0001-Align-the-data-block-sizes-of-pg_dump-s-various-c.patch) at 2025-10-15 19:21:50 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v4-0001-Align-the-data-block-sizes-of-pg_dump-s-various-c.patch) at 2025-10-13 21:07:52 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v3-0001-Fix-poor-buffering-logic-in-pg_dump-s-lz4-and-zst.patch) at 2025-10-12 01:25:20 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v2-0001-Fix-poor-buffering-logic-in-pg_dump-s-lz4-and-zst.patch) at 2025-10-11 02:22:16 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v1-improve-pg_dump-compress-buffering.patch) at 2025-10-10 20:26:57 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v3-0001-parallel-pg_restore-avoid-disk-seeks-when-moving-.patch) at 2025-06-09 20:09:57 from Dimitrios Apostolou <jimis at gmx.net> (Patch: Yes)
    Attachment (v2-0001-parallel-pg_restore-avoid-disk-seeks-when-jumping.patch) at 2025-04-04 16:55:44 from Dimitrios Apostolou <jimis at gmx.net> (Patch: Yes)
    Attachment (v1-0001-parallel-pg_restore-avoid-disk-seeks-when-jumping.patch) at 2025-03-29 00:46:30 from Dimitrios Apostolou <jimis at gmx.net> (Patch: Yes)
History
When Who What
2025-10-21 21:29:13 Tom Lane (tgl) Closed in commitfest PG19-3 with status: Committed
2025-10-21 21:29:12 Tom Lane (tgl) Changed committer to tgl
2025-10-20 19:02:27 CFbot Patch does not need rebase anymore
2025-10-17 06:17:47 CFbot Patch needs rebase
2025-10-05 18:27:01 Tom Lane (tgl) Moved from CF PG19-1 to CF PG19-3
2025-09-16 22:58:02 Tom Lane (tgl) Added tgl as reviewer
2025-09-02 19:39:32 Nathan Bossart (bossartn) Removed bossartn from reviewers
2025-06-18 20:11:12 Nathan Bossart (bossartn) Changed targetversion to 19
2025-06-09 21:26:54 Nathan Bossart (bossartn) Added bossartn as reviewer
2025-06-09 20:01:41 Dimitrios Apostolou (jimis) Attached mail thread 2edb7a57-b225-3b23-a680-62ba90658fec@gmx.net
2025-06-09 20:01:41 Dimitrios Apostolou (jimis) Created patch record
Edit