speed up a logical replication setup (pg_subscriber)

Edit
ID 4636
Title speed up a logical replication setup (pg_subscriber)
Topic Replication & Recovery
Created 2023-10-31 21:34:01
Last modified 2023-11-01 14:01:04 (11 months ago)
Latest email 2024-03-26 21:29:19 (6 months, 1 week ago)
Status
2023-11: Withdrawn
Target version
Authors
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/4636
git checkout commitfest/cf/4636
Emails
speed up a logical replica setup
First at 2022-02-21 12:09:12 by "Euler Taveira" <euler at eulerto.com>
Latest at 2024-03-26 21:29:19 by Tomas Vondra <tomas.vondra at enterprisedb.com>
Latest attachment (v1-0001-Improve-the-code-that-checks-if-the-recovery-is-f.patch) at 2024-03-26 02:53:21 from "Euler Taveira" <euler at eulerto.com>
    Attachment (v1-0001-Improve-the-code-that-checks-if-the-recovery-is-f.patch) at 2024-03-26 02:53:21 from "Euler Taveira" <euler at eulerto.com> (Patch: Yes)
    Attachment (v34-0001-pg_createsubscriber-creates-a-new-logical-replic.patch) at 2024-03-25 11:48:05 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (valgrind.log) at 2024-03-22 14:15:35 from Shubham Khanna <khannashubham1197 at gmail.com> (Patch: No)
    Attachment (v33-0001-pg_createsubscriber-creates-a-new-logical-replic.patch.gz) at 2024-03-22 03:31:34 from "Euler Taveira" <euler at eulerto.com> (Patch: No)
    Attachment (v32-0003-Fix-compilation-error.patch) at 2024-03-21 09:49:16 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v32-0001-pg_createsubscriber-creates-a-new-logical-replic.patch.gz) at 2024-03-21 04:19:10 from "Euler Taveira" <euler at eulerto.com> (Patch: No)
    Attachment (v31-0001-pg_createsubscriber-creates-a-new-logical-replic.patch) at 2024-03-20 10:16:13 from Shubham Khanna <khannashubham1197 at gmail.com> (Patch: Yes)
    Attachment (v31-0001-pg_createsubscriber-creates-a-new-logical-replic.patch) at 2024-03-20 06:14:24 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v30-0001-pg_createsubscriber-creates-a-new-logical-replic.patch) at 2024-03-19 11:26:10 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (0001-Various-improvements.patch) at 2024-03-18 13:52:28 from Peter Eisentraut <peter at eisentraut.org> (Patch: Yes)
    Attachment (0001-fixup-pg_createsubscriber-creates-a-new-logical-repl.patch) at 2024-03-18 11:15:16 from Peter Eisentraut <peter at eisentraut.org> (Patch: Yes)
    Attachment (v30-0001-pg_createsubscriber-creates-a-new-logical-replic.patch.gz) at 2024-03-16 15:42:51 from "Euler Taveira" <euler at eulerto.com> (Patch: No)
    Attachment (v29-0002-Keep-standby-server-s-minimum-recovery-point-les.patch) at 2024-03-16 13:31:02 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v29-0001-pg_createsubscriber-creates-a-new-logical-replic.patch.gz) at 2024-03-15 03:51:48 from "Euler Taveira" <euler at eulerto.com> (Patch: No)
    Attachment (v28-0001-pg_createsubscriber-creates-a-new-logical-replic.patch) at 2024-03-13 13:09:21 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v28-0001-pg_createsubscriber-creates-a-new-logical-replic.patch) at 2024-03-13 07:47:52 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v28-0001-pg_createsubscriber-creates-a-new-logical-replic.patch.gz) at 2024-03-13 06:10:21 from "Euler Taveira" <euler at eulerto.com> (Patch: No)
    Attachment (v27-0005-Fix-error-for-windows.patch) at 2024-03-11 03:56:52 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v27-0004-Add-additional-testcases.patch) at 2024-03-08 07:03:00 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v27-0001-pg_createsubscriber-creates-a-new-logical-replic.patch) at 2024-03-07 13:01:38 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v26-0001-pg_createsubscriber-creates-a-new-logical-replic.patch.gz) at 2024-03-07 04:34:38 from "Euler Taveira" <euler at eulerto.com> (Patch: No)
    Attachment (0001-Shorten-main-function.txt) at 2024-03-06 10:02:06 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v25-0001-pg_createsubscriber-creates-a-new-logical-replic.patch) at 2024-03-01 20:48:20 from "Euler Taveira" <euler at eulerto.com> (Patch: Yes)
    Attachment (v24-0001-Creates-a-new-logical-replica-from-a-standby-ser.patch) at 2024-02-22 15:45:02 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v23-0001-Creates-a-new-logical-replica-from-a-standby-ser.patch) at 2024-02-21 08:00:49 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (debug.sh) at 2024-02-19 10:22:34 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: No)
    Attachment (v22-0001-Creates-a-new-logical-replica-from-a-standby-ser.patch) at 2024-02-19 05:45:38 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (cascade_3node_setup_without_slots.sh) at 2024-02-16 09:20:05 from Shubham Khanna <khannashubham1197 at gmail.com> (Patch: No)
    Attachment (v21-0001-Creates-a-new-logical-replica-from-a-standby-ser.patch) at 2024-02-16 03:14:38 from "Euler Taveira" <euler at eulerto.com> (Patch: Yes)
    Attachment (v20-0001-Creates-a-new-logical-replica-from-a-standby-ser.patch) at 2024-02-15 11:23:16 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (cascade_replication.sh) at 2024-02-15 05:27:48 from Shubham Khanna <khannashubham1197 at gmail.com> (Patch: No)
    Attachment (v19-0008-Fix-error-message-for-get_bin_directory.patch) at 2024-02-13 12:55:51 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (N1.log) at 2024-02-09 12:03:15 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: No)
    Attachment (v18-0001-Creates-a-new-logical-replica-from-a-standby-ser.patch) at 2024-02-08 14:22:21 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (test_0207.sh) at 2024-02-07 09:17:28 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: No)
    Attachment (v17-0001-Creates-a-new-logical-replica-from-a-standby-ser.patch) at 2024-02-07 04:53:37 from "Euler Taveira" <euler at eulerto.com> (Patch: Yes)
    Attachment (v16-0005-Avoid-stopping-starting-standby-server-in-dry_ru.patch) at 2024-02-06 10:26:21 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (shorter_subconninfo.sh) at 2024-02-06 08:44:44 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: No)
    Attachment (server_start_20240206T080003.670.log) at 2024-02-06 08:27:55 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: No)
    Attachment (v15-0001-Creates-a-new-logical-replica-from-a-standby-ser.patch) at 2024-02-02 09:41:35 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v14-0001-Creates-a-new-logical-replica-from-a-standby-ser.patch) at 2024-02-02 02:04:15 from "Euler Taveira" <euler at eulerto.com> (Patch: Yes)
    Attachment (v13-0001-Creates-a-new-logical-replica-from-a-standby-ser.patch) at 2024-02-01 12:47:06 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (test_0201.sh) at 2024-02-01 03:26:25 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: No)
    Attachment (server_start_20240131T115324.735.log) at 2024-01-31 14:55:59 from Fabrízio de Royes Mello <fabriziomello at gmail.com> (Patch: No)
    Attachment (v12-0001-Creates-a-new-logical-replica-from-a-standby-ser.patch) at 2024-01-31 12:52:23 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v11-0001-Creates-a-new-logical-replica-from-a-standby-ser.patch) at 2024-01-30 02:01:38 from "Euler Taveira" <euler at eulerto.com> (Patch: Yes)
    Attachment (v10-0001-Creates-a-new-logical-replica-from-a-standby-ser.patch) at 2024-01-29 09:57:44 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v9-0001-Creates-a-new-logical-replica-from-a-standby-serv.patch) at 2024-01-25 23:34:46 from "Euler Taveira" <euler at eulerto.com> (Patch: Yes)
    Attachment (run.sh) at 2024-01-25 05:54:32 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: No)
    Attachment (v8-0001-Creates-a-new-logical-replica-from-a-standby-serv.patch) at 2024-01-24 11:43:00 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v7-0001-Creates-a-new-logical-replica-from-a-standby-serv.patch) at 2024-01-23 02:11:26 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v6-0003-Fix-publication-does-not-exist-error.patch) at 2024-01-22 09:30:05 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (logical_replication.pl) at 2024-01-19 08:48:53 from Shubham Khanna <khannashubham1197 at gmail.com> (Patch: No)
    Attachment (v20240117-0001-Creates-a-new-logical-replica-from-a-stand.patch) at 2024-01-17 07:28:55 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (pg_subscriber.pl) at 2024-01-16 06:28:10 from Shubham Khanna <khannashubham1197 at gmail.com> (Patch: No)
    Attachment (v5-0001-Creates-a-new-logical-replica-from-a-standby-serv.patch) at 2024-01-11 22:15:22 from "Euler Taveira" <euler at eulerto.com> (Patch: Yes)
    Attachment (v4-0001-Creates-a-new-logical-replica-from-a-standby-serv.patch) at 2024-01-11 12:18:01 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v1-0001-Restrict-pg_subscriber-to-standby-node.patch) at 2024-01-10 04:33:51 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Creates-a-new-logical-replica-from-a-standby-serv.patch) at 2023-12-06 07:21:44 from "Euler Taveira" <euler at eulerto.com> (Patch: Yes)
    Attachment (v2-0001-Creates-a-new-logical-replica-from-a-standby-serv.patch) at 2023-10-23 03:53:21 from "Euler Taveira" <euler at eulerto.com> (Patch: Yes)
    Attachment (0001-fixup-Create-a-new-logical-replica-from-a-base-backu.patch) at 2022-03-15 13:51:11 from Peter Eisentraut <peter.eisentraut at enterprisedb.com> (Patch: Yes)
    Attachment (v1-0001-Move-readfile-and-free_readfile-to-file_utils.h.patch) at 2022-02-21 12:09:12 from "Euler Taveira" <euler at eulerto.com> (Patch: Yes)
History
When Who What
2023-11-01 14:01:04 Euler Taveira (eulerto) Closed in commitfest 2023-11 with status: Withdrawn
2023-11-01 02:46:41 shihao zhong (zhong950419) Posted comment with messageid <169880680142.94392.3599730105757608388.pgcf@coridan.postgresql.org>
2023-11-01 02:46:41 shihao zhong (zhong950419) New status: Waiting on Author
2023-10-31 21:34:01 Euler Taveira (eulerto) Attached mail thread 5ac50071-f2ed-4ace-a8fd-b892cffd33eb@www.fastmail.com
2023-10-31 21:34:01 Euler Taveira (eulerto) Created patch record
Edit