improve large object handling in pg

improve large object handling in pg_upgrade

3841

Title

improve large object handling in pg_upgrade

Topic

Miscellaneous

Created

2022-08-25 00:27:04

Last modified

2022-10-12 05:50:15 (2 years, 1 month ago)

Latest email

2024-04-01 19:37:18 (7 months, 2 weeks ago)

Status

2022-09: Returned with feedback

Target version

Authors

Nathan Bossart (bossartn), Jan Wieck (wieck)

Reviewers

Become reviewer

Committer

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/3841
git checkout commitfest/cf/3841

Emails

Re: pg_upgrade failing for 200+ million Large Objects: First at 2021-03-08 11:02:04 by "Tharakan, Robins" <tharar at amazon.com>
Latest at 2024-04-01 19:37:18 by Nathan Bossart <nathandbossart at gmail.com>
Latest attachment (v11-0001-Some-small-preliminaries-for-pg_dump-changes.patch) at 2024-03-15 23:18:41 from Tom Lane <tgl at sss.pgh.pa.us>
    Attachment (v11-0001-Some-small-preliminaries-for-pg_dump-changes.patch) at 2024-03-15 23:18:41 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v10-0001-Some-small-preliminaries-for-pg_dump-changes.patch) at 2024-01-26 16:44:26 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v9-005-parallel_pg_restore.patch) at 2024-01-02 17:33:00 from "Kumar, Sachin" <ssetiya at amazon.com> (Patch: Yes)
    Attachment (v9_1M_100kb_restore_times.png) at 2023-12-28 11:38:46 from Robins Tharakan <tharakan at gmail.com> (Patch: No)
    Attachment (v9_dump.png) at 2023-12-27 13:28:01 from Robins Tharakan <tharakan at gmail.com> (Patch: No)
    Attachment (v9-0001-Some-small-preliminaries-for-pg_dump-changes.patch) at 2023-12-20 23:47:44 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v8-0001-restore-transaction-size-option.patch) at 2023-12-11 01:42:42 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (pg_upgrade_improvements_v7.diff) at 2023-12-04 16:07:59 from "Kumar, Sachin" <ssetiya at amazon.com> (Patch: Yes)
    Attachment (pg_upgrade_improvements_v6.diff) at 2023-11-13 15:06:31 from "Kumar, Sachin" <ssetiya at amazon.com> (Patch: Yes)
    Attachment (pg_upgrade_improvements_v5.diff) at 2022-08-25 00:32:27 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (pg_upgrade_improvements.v4.diff) at 2021-03-24 16:05:27 from Jan Wieck <jan at wi3ck.info> (Patch: Yes)
    Attachment (pg_upgrade_improvements.v3.diff) at 2021-03-23 12:51:32 from Jan Wieck <jan at wi3ck.info> (Patch: Yes)
    Attachment (pg_upgrade_improvements.v2.diff) at 2021-03-22 18:07:34 from Jan Wieck <jan at wi3ck.info> (Patch: Yes)
    Attachment (upgrade-test-dbownership.patch) at 2021-03-21 19:29:10 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (pg_restore-preserve-datdba.v1.diff) at 2021-03-21 17:50:45 from Jan Wieck <jan at wi3ck.info> (Patch: Yes)
    Attachment (pg_upgrade-preserve-datdba.v1.diff) at 2021-03-21 16:50:46 from Jan Wieck <jan at wi3ck.info> (Patch: Yes)

History

When	Who	What
2022-10-12 05:50:15	Michael Paquier (michael-kun)	Closed in commitfest 2022-09 with status: Returned with feedback
2022-09-23 16:35:24	Nathan Bossart (bossartn)	New status: Waiting on Author
2022-08-25 00:27:29	Nathan Bossart (bossartn)	Changed authors to Nathan Bossart (bossartn), Jan Wieck (wieck)
2022-08-25 00:27:29	Nathan Bossart (bossartn)	Changed targetversion to 16
2022-08-25 00:27:04	Nathan Bossart (bossartn)	Attached mail thread a9f9376f1c3343a6bb319dce294e20ac@EX13D05UWC001.ant.amazon.com
2022-08-25 00:27:04	Nathan Bossart (bossartn)	Created patch record