inefficiency in parallel pg_restore with many tables

4452

Title

Topic

Performance

Created

2023-07-20 19:07:24

Last modified

2023-09-20 02:28:50 (1 year, 2 months ago)

Latest email

2023-09-20 02:30:33 (1 year, 2 months ago)

Status

2023-09: Committed

Target version

Authors

Nathan Bossart (bossartn)

Reviewers

Tom Lane (tgl)Become reviewer

Committer

Nathan Bossart (bossartn)

Links

CFbot results (CirrusCI) CFbot GitHub

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/4452
git checkout commitfest/cf/4452

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