pg_upgrade: retrieve subscription count more efficiently

Edit
Title pg_upgrade: retrieve subscription count more efficiently
Topic Performance
Created 2024-07-21 02:03:51
Last modified 2024-07-24 16:34:06 (1 month, 2 weeks ago)
Latest email 2024-07-25 08:16:58 (1 month, 1 week ago)
Status
2024-09: Committed
Target version 17
Authors Nathan Bossart (bossartn)
Reviewers Become reviewer
Committer Nathan Bossart (bossartn)
Links
Emails
pg_upgrade and logical replication
First at 2023-02-17 07:54:33 by Julien Rouhaud <rjuju123 at gmail.com>
Latest at 2024-07-25 08:16:58 by Michael Paquier <michael at paquier.xyz>
Latest attachment (v3-0001-pg_upgrade-retrieve-subscription-count-more-effic.patch) at 2024-07-23 19:55:28 from Nathan Bossart <nathandbossart at gmail.com>
    Attachment (v3-0001-pg_upgrade-retrieve-subscription-count-more-effic.patch) at 2024-07-23 19:55:28 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v2-0001-pg_upgrade-retrieve-subscription-count-more-effic.patch) at 2024-07-22 14:46:29 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v1-0001-pg_upgrade-retrieve-subscription-count-more-effic.patch) at 2024-07-21 02:03:07 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Fix-random-upgrade-failure-test-in-004_subscripti.patch) at 2024-03-27 06:27:29 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Fix-testcase.patch) at 2024-02-19 01:24:35 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v4-0001-Fix-testcase.patch) at 2024-02-16 05:20:33 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v3-0001-Fix-testcase.patch) at 2024-02-16 02:52:01 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v2-0001-Fix-testcase.patch) at 2024-02-14 05:21:54 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (0001-Fix-testcase.patch) at 2024-02-14 03:37:03 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v26-0001-Allow-upgrades-to-preserve-the-full-subscription.patch) at 2023-12-28 10:29:04 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v25-0001-Allow-upgrades-to-preserve-the-full-subscription.patch) at 2023-12-13 06:39:25 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v24-0001-Allow-upgrades-to-preserve-the-full-subscription.patch) at 2023-12-07 11:14:36 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v23-0001-Allow-upgrades-to-preserve-the-full-subscription.patch) at 2023-12-04 11:00:49 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v22-0001-Preserve-the-full-subscription-s-state-during-pg.patch) at 2023-12-01 17:54:41 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v21-0001-Preserve-the-full-subscription-s-state-during-pg.patch) at 2023-11-30 16:25:21 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (changes_by_amit_1.patch.txt) at 2023-11-29 09:32:02 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v20-0002-Retain-the-subscription-oids-during-upgrade.patch) at 2023-11-28 10:42:23 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v19-0001-Preserve-the-full-subscription-s-state-during-pg.patch) at 2023-11-25 01:51:04 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v19-0001-Preserve-the-full-subscription-s-state-during-pg.patch) at 2023-11-24 15:35:26 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v18-0001-Preserve-the-full-subscription-s-state-during-pg.patch) at 2023-11-23 08:43:45 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v17-0001-Preserve-the-full-subscription-s-state-during-pg.patch) at 2023-11-22 11:55:16 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v16-0001-Preserve-the-full-subscription-s-state-during-pg.patch) at 2023-11-21 17:33:36 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v15-0001-Preserve-the-full-subscription-s-state-during-pg.patch) at 2023-11-19 03:38:39 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Retain-the-subscription-oids-during-upgrade.patch) at 2023-11-19 01:26:05 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (upgrade_retain_subscription_oid.patch) at 2023-11-19 01:22:09 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v14-0001-Preserve-the-full-subscription-s-state-during-pg.patch) at 2023-11-15 18:03:28 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v13-0001-Preserve-the-full-subscription-s-state-during-pg.patch) at 2023-11-10 13:56:18 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v12-0001-Preserve-the-full-subscription-s-state-during-pg.patch) at 2023-11-08 06:21:06 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (0001-Added-GUC-hook-for-max_logical_replication_workers.patch) at 2023-11-03 10:45:45 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v11-0001-Preserve-the-full-subscription-s-state-during-pg.patch) at 2023-11-02 10:11:25 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v10-0001-Prevent-startup-of-logical-replication-launcher-.patch) at 2023-11-01 18:44:05 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v9_20231030-0001-Prevent-startup-of-logical-replication-launcher-i.patch) at 2023-10-30 09:35:09 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Prevent-startup-of-logical-replication-launcher-i.patch) at 2023-10-27 06:39:27 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (0001-Prevent-startup-of-logical-replication-launcher-in-b.patch) at 2023-09-25 01:57:28 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (v1-0001-Don-t-start-launcher-process-to-be-started-while-.patch) at 2023-09-19 13:44:49 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Don-t-start-launcher-process-in-binary-upgrade-mo.patch) at 2023-09-15 09:38:21 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (test.sh) at 2023-09-12 08:55:50 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: No)
    Attachment (v7-0001-Preserve-the-full-subscription-s-state-during-pg_.patch) at 2023-09-11 10:31:52 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Optionally-preserve-the-full-subscription-s-state.patch) at 2023-09-06 10:58:39 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Optionally-preserve-the-full-subscription-s-state.patch) at 2023-04-24 07:22:24 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Optionally-preserve-the-full-subscription-s-state.patch) at 2023-04-07 02:28:02 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Optionally-preserve-the-full-subscription-s-state.patch) at 2023-03-27 08:49:55 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Optionally-preserve-the-full-subscription-s-state.patch) at 2023-03-09 08:34:56 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-POC-Preserve-the-subscription-relations-during-pg.patch) at 2023-02-22 06:43:18 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
History
When Who What
2024-07-24 16:34:06 Nathan Bossart (bossartn) Closed in commitfest 2024-09 with status: Committed
2024-07-24 16:34:06 Nathan Bossart (bossartn) Changed committer to bossartn
2024-07-21 02:03:58 Nathan Bossart (bossartn) Changed authors to Nathan Bossart (bossartn)
2024-07-21 02:03:58 Nathan Bossart (bossartn) Changed targetversion to 17
2024-07-21 02:03:52 Nathan Bossart (bossartn) Attached mail thread 20230217075433.u5mjly4d5cr4hcfe@jrouhaud
2024-07-21 02:03:51 Nathan Bossart (bossartn) Created patch record
Edit