speed up a logical replication setup (pg_subscriber)

Edit
ID 3556
Title speed up a logical replication setup (pg_subscriber)
Topic Replication & Recovery
Created 2022-02-22 20:45:44
Last modified 2022-08-02 18:56:11 (2 years, 3 months ago)
Latest email 2024-03-26 21:29:19 (7 months, 1 week ago)
Status
2022-07: Returned with feedback
2022-03: Moved to next CF
Target version
Authors Euler Taveira (eulerto)
Reviewers Peter Eisentraut (petere)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/3556
git checkout commitfest/cf/3556
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
2022-08-02 18:56:11 Jacob Champion (jchampion) Closed in commitfest 2022-07 with status: Returned with feedback
2022-03-29 12:33:42 Peter Eisentraut (petere) New status: Waiting on Author
2022-03-29 12:33:24 Peter Eisentraut (petere) Closed in commitfest 2022-03 with status: Moved to next CF
2022-03-14 13:25:54 Peter Eisentraut (petere) Changed name to speed up a logical replication setup (pg_subscriber)
2022-03-04 08:45:00 Peter Eisentraut (petere) Added petere as reviewer
2022-02-22 20:46:21 Euler Taveira (eulerto) Changed authors to Euler Taveira (eulerto)
2022-02-22 20:45:44 Euler Taveira (eulerto) Attached mail thread 5ac50071-f2ed-4ace-a8fd-b892cffd33eb@www.fastmail.com
2022-02-22 20:45:44 Euler Taveira (eulerto) Created patch record
Edit