pg_upgrade: retrieve subscription count more efficiently

Edit
ID 5135
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 (3 months, 3 weeks ago)
Latest email 2024-07-25 08:16:58 (3 months, 3 weeks ago)
Status
2024-09: Committed
Target version 17
Authors Nathan Bossart (bossartn)
Reviewers Become reviewer
Committer Nathan Bossart (bossartn)
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/5135
git checkout commitfest/cf/5135
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