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: v2, Patch count: 1, First patch: +90−7, All patches: +90−7
Topic Performance
Created 2025-05-05 19:24:43
Last modified 2025-05-05 19:24:43 (3 days ago)
Latest email 2025-05-07 14:51:19 (yesterday)
Status
2025-07: Needs review
Target version 19
Authors Nathan Bossart (bossartn)
Reviewers 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-05-07 14:51:19 by Nathan Bossart <nathandbossart at gmail.com>
Latest 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>
    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-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