speed up pg_upgrade with many large objects

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v5, Patch count: 1, First patch: +103−6, All patches: +103−6

Topic

Performance

Tags

Created

2025-05-05 19:24:43

Last modified

2025-07-18 16:06:06 (7 hours ago)

Latest email

2025-07-18 16:05:04 (7 hours ago)

Status

PG19-1 (2025-07-01 - 2025-07-31): Committed

Target version

Authors

Nathan Bossart (bossartn)

Reviewers

Hannu Krosing (hannukrosing), Saurabh Uttam (saurabhuttam), Nitin Motiani (nitinmotiani)Become reviewer

Committer

Nathan Bossart (bossartn)

Links

Emails

Horribly slow pg_upgrade performance with many Large Objects: First at 2025-04-07 20:33:47 by Hannu Krosing <hannuk at google.com>
Latest at 2025-07-18 16:05:04 by Nathan Bossart <nathandbossart at gmail.com>
Latest attachment (v5-0001-pg_upgrade-Use-COPY-for-large-object-metadata.patch) at 2025-07-14 17:51:20 from Nathan Bossart <nathandbossart at gmail.com>
    Attachment (v5-0001-pg_upgrade-Use-COPY-for-large-object-metadata.patch) at 2025-07-14 17:51:20 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v4-0001-pg_upgrade-Use-COPY-for-large-object-metadata.patch) at 2025-07-14 16:24:14 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v3-0001-pg_upgrade-Use-COPY-for-large-object-metadata.patch) at 2025-07-10 21:42:23 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v2-0001-pg_upgrade-Use-COPY-for-large-object-metadata.patch) at 2025-05-07 14:51:19 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v1-0001-pg_upgrade-Use-COPY-for-large-object-metadata.patch) at 2025-05-05 19:23:25 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Mention-that-we-preserve-database-OIDs-in-pg_upgr.patch) at 2025-04-09 17:16:44 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)

History

When	Who	What
2025-07-18 16:06:06	Nathan Bossart (bossartn)	Closed in commitfest PG19-1 with status: Committed
2025-07-11 14:51:55	Nathan Bossart (bossartn)	Added bossartn as committer
2025-07-11 14:51:54	Nathan Bossart (bossartn)	New status: Ready for Committer
2025-05-14 16:25:12	Saurabh Uttam (saurabhuttam)	Added saurabhuttam as reviewer
2025-05-14 16:19:35	Nitin Motiani (nitinmotiani)	Added nitinmotiani as reviewer
2025-05-13 20:21:54	Hannu Krosing (hannukrosing)	Added hannukrosing as reviewer
2025-05-05 19:24:43	Nathan Bossart (bossartn)	Attached mail thread CAMT0RQSS-6qLH+zYsOeUbAYhop3wmQTkNmQpo5--QRDUR+qYmQ@mail.gmail.com
2025-05-05 19:24:43	Nathan Bossart (bossartn)	Created patch record