speed up pg_upgrade with many large objects

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v3, Patch count: 1, First patch: +97−6, All patches: +97−6

Topic

Performance

Tags

Created

2025-05-05 19:24:43

Last modified

2025-05-05 19:24:43 (2 months ago)

Latest email

2025-07-10 21:42:23 (13 hours ago)

Status

PG19-1 (2025-07-01 - 2025-07-31): Needs review

Target version

Authors

Nathan Bossart (bossartn)

Reviewers

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

Committer

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-10 21:42:23 by Nathan Bossart <nathandbossart at gmail.com>
Latest 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>
    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-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