inefficiency in parallel pg_restore with many tables

Title

Topic

Performance

Created

2023-07-20 19:07:24

Last modified

2023-09-20 02:28:50 (7 months, 1 week ago)

Latest email

2023-09-20 02:30:33 (7 months, 1 week ago)

Status

2023-09: Committed

Target version

Authors

Nathan Bossart (bossartn)

Reviewers

Tom Lane (tgl)Become reviewer

Committer

Nathan Bossart (bossartn)

Links

Emails

Inefficiency in parallel pg_restore with many tables: First at 2023-07-15 17:47:12 by Tom Lane <tgl at sss.pgh.pa.us>
Latest at 2023-09-20 02:30:33 by Nathan Bossart <nathandbossart at gmail.com>
Latest attachment (v10-0001-Make-binaryheap-available-to-frontend-code.patch) at 2023-09-14 03:45:39 from Nathan Bossart <nathandbossart at gmail.com>
    Attachment (v10-0001-Make-binaryheap-available-to-frontend-code.patch) at 2023-09-14 03:45:39 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Make-binaryheap-available-to-frontend-code.patch) at 2023-09-13 22:47:53 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Make-binaryheap-available-to-frontend-code.patch) at 2023-09-13 18:34:50 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Allow-binaryheap-to-use-any-type.patch) at 2023-09-04 23:08:29 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (0001-allow-binaryheap-to-use-any-type.patch) at 2023-09-02 18:55:21 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Make-binaryheap-available-to-frontend-code.patch) at 2023-07-25 18:53:36 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v5-0001-make-binaryheap-available-to-frontend.patch) at 2023-07-24 19:00:15 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v4-0001-use-void-instead-of-Datum-in-binaryheap.patch) at 2023-07-23 05:57:03 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v3-0001-move-datum-definitions-to-c.h.patch) at 2023-07-22 23:19:41 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v2-0001-misc-binaryheap-fixes.patch) at 2023-07-20 19:06:44 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (expand_binaryheap_api.patch) at 2023-07-18 04:57:01 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)

History

When	Who	What
2023-09-20 02:28:50	Nathan Bossart (bossartn)	Closed in commitfest 2023-09 with status: Committed
2023-09-13 18:36:26	Nathan Bossart (bossartn)	Added bossartn as committer
2023-09-10 16:35:45	Tom Lane (tgl)	New status: Ready for Committer
2023-09-01 17:36:32	Tom Lane (tgl)	Added tgl as reviewer
2023-07-20 19:07:32	Nathan Bossart (bossartn)	Changed authors to Nathan Bossart (bossartn)
2023-07-20 19:07:32	Nathan Bossart (bossartn)	Changed targetversion to 17
2023-07-20 19:07:25	Nathan Bossart (bossartn)	Attached mail thread 3612876.1689443232@sss.pgh.pa.us
2023-07-20 19:07:24	Nathan Bossart (bossartn)	Created patch record