speed up pg_upgrade with many large objects

Edit
ID 5737
Title speed up pg_upgrade with many large objects
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 19
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
Edit