Minimal logical decoding on standbys

Edit
ID 3740
Title Minimal logical decoding on standbys
Topic Replication & Recovery
Created 2022-06-30 14:45:01
Last modified 2023-04-08 16:31:01 (1 year, 6 months ago)
Latest email 2023-04-08 17:12:16 (1 year, 6 months ago)
Status
2023-03: Committed
2023-01: Moved to next CF
2022-11: Moved to next CF
2022-09: Moved to next CF
2022-07: Moved to next CF
Target version 16
Authors Bertrand Drouvot (bdrouvot)
Reviewers Bharath Rupireddy (bharathrupireddy)Become reviewer
Committer Andres Freund (andresfreund)
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/3740
git checkout commitfest/cf/3740
Emails
Minimal logical decoding on standbys
First at 2018-12-12 20:41:54 by Andres Freund <andres at anarazel.de>
Latest at 2023-04-08 17:12:16 by "Jonathan S. Katz" <jkatz at postgresql.org>
Latest attachment (sub_in_progress.patch) at 2023-04-07 20:58:19 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com>
    Attachment (sub_in_progress.patch) at 2023-04-07 20:58:19 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (va67-0001-Replace-a-replication-slot-s-invalidated_at-LSN.patch) at 2023-04-07 18:12:26 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (v65-66-InvalidateObsoleteReplicationSlots_API.patch) at 2023-04-07 15:13:13 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (va65-0001-replication-slots-replace-invalidated_at-LSN-wi.patch) at 2023-04-07 07:50:09 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (v62-63-0005-New-TAP-test-for-logical-decoding-on-standby.patch) at 2023-04-07 06:09:50 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v63-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-04-07 05:02:04 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v62-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-04-06 13:00:57 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v61-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-04-05 15:56:14 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v60-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-04-05 07:59:24 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v59-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-04-04 14:53:31 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v58-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-04-04 09:42:45 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v57-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-04-03 18:17:19 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v56-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-04-03 15:20:55 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v55-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-04-02 08:27:45 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v54-0007-Doc-changes-describing-details-about-logical-dec.patch) at 2023-03-31 10:45:51 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Introduce-ConditionVariableEventSleep.patch) at 2023-03-31 09:44:33 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (v53-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-03-30 16:23:41 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (0004_new_API.txt) at 2023-03-10 11:33:50 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (0004_new_API.txt) at 2023-03-08 10:25:10 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v52-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-03-04 11:19:57 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Introduce-ConditionVariableEventSleep.patch) at 2023-03-03 07:58:07 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (0004-CV-POC.txt) at 2023-03-02 09:20:09 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v51-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-02-27 08:40:58 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v50-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-02-13 15:27:20 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v49-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-02-07 15:29:07 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v48-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-02-07 10:36:48 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v47-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-02-06 11:36:56 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v46-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-01-31 11:50:50 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v45-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-01-30 16:18:39 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v44-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-01-27 12:09:16 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v43-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-01-26 17:56:10 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v42-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-01-23 11:03:35 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v41-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-01-19 08:13:22 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v40-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-01-16 14:28:54 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v39-0006-Fixing-Walsender-corner-case-with-logical-decodi.patch) at 2023-01-12 11:57:39 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v38-0006-Fixing-Walsender-corner-case-with-logical-decodi.patch) at 2023-01-11 18:04:48 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v37-0006-Fixing-Walsender-corner-case-with-logical-decodi.patch) at 2023-01-10 08:33:21 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v36-0006-Fixing-Walsender-corner-case-with-logical-decodi.patch) at 2023-01-03 07:41:22 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v35-0006-Fixing-Walsender-corner-case-with-logical-decodi.patch) at 2022-12-22 07:50:34 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v1-0001-fix-some-comments.patch) at 2022-12-21 09:06:42 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (kpt_gist_setup.sql) at 2022-12-20 21:41:54 from Robert Haas <robertmhaas at gmail.com> (Patch: No)
    Attachment (kpt_hash_setup.sql) at 2022-12-20 20:39:26 from Robert Haas <robertmhaas at gmail.com> (Patch: No)
    Attachment (v34-0006-Fixing-Walsender-corner-case-with-logical-decodi.patch) at 2022-12-20 20:35:13 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v33-0006-Fixing-Walsender-corner-case-with-logical-decodi.patch) at 2022-12-20 09:51:59 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v32-0006-Fixing-Walsender-corner-case-with-logical-decodi.patch) at 2022-12-16 10:33:50 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v31-0006-Fixing-Walsender-corner-case-with-logical-decodi.patch) at 2022-12-14 13:05:15 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v30-0006-Fixing-Walsender-corner-case-with-logical-decodi.patch) at 2022-12-10 08:09:27 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v29-0006-Fixing-Walsender-corner-case-with-logical-decodi.patch) at 2022-12-08 11:07:22 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v28-0006-Fixing-Walsender-corner-case-with-logical-decodi.patch) at 2022-12-07 09:00:25 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v27-0006-Fixing-Walsender-corner-case-with-logical-decodi.patch) at 2022-12-02 09:32:23 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v27-0001-Add-info-in-WAL-records-in-preparation-for-logic.patch) at 2022-11-25 10:26:16 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v26-0001-Add-info-in-WAL-records-in-preparation-for-logic.patch) at 2022-09-30 12:11:39 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v25-0001-Add-info-in-WAL-records-in-preparation-for-logic.patch) at 2021-10-27 06:55:45 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v24-0001-Add-info-in-WAL-records-in-preparation-for-logic.patch) at 2021-09-15 11:36:00 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v23-0006-Logical-Decoding-On-Standby-WalSender-Corner-Case.patch) at 2021-09-08 10:08:43 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v23-0005-Doc-changes-describing-details-about-logical-dec.patch) at 2021-08-06 11:27:46 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v22-0005-Doc-changes-describing-details-about-logical-dec.patch) at 2021-08-02 14:45:23 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v21-0005-Doc-changes-describing-details-about-logical-dec.patch) at 2021-07-27 07:23:48 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v20-0005-Doc-changes-describing-details-about-logical-dec.patch) at 2021-07-16 08:07:10 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v19-0005-Doc-changes-describing-details-about-logical-dec.patch) at 2021-06-22 10:38:34 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v18-0001-Add-info-in-WAL-records-in-preparation-for-logic.patch) at 2021-06-14 05:41:12 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v17-0005-Doc-changes-describing-details-about-logical-dec.patch) at 2021-04-08 10:19:00 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v16-0001-Allow-logical-decoding-on-standby.patch) at 2021-04-07 09:06:11 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v15-0005-Doc-changes-describing-details-about-logical-dec.patch) at 2021-04-06 12:30:29 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v14-0005-Doc-changes-describing-details-about-logical-dec.patch) at 2021-03-24 06:56:51 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v13-0005-Doc-changes-describing-details-about-logical-dec.patch) at 2021-03-23 17:31:48 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v12-0005-Doc-changes-describing-details-about-logical-dec.patch) at 2021-03-23 11:47:29 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v11-0005-Doc-changes-describing-details-about-logical-dec.patch) at 2021-03-22 15:56:36 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v10-0005-Doc-changes-describing-details-about-logical-dec.patch) at 2021-03-18 08:33:45 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v9-0001-Allow-logical-decoding-on-standby.patch) at 2021-02-04 16:49:23 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v8-0005-Doc-changes-describing-details-about-logical-deco.patch) at 2021-01-26 09:31:33 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v8-0001-Allow-logical-decoding-on-standby.patch) at 2021-01-18 11:48:31 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v7-0001-Allow-logical-decoding-on-standby.patch) at 2020-12-15 18:24:38 from Fabrízio de Royes Mello <fabriziomello at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Allow-logical-decoding-on-standby.patch) at 2020-03-18 18:29:46 from Alvaro Herrera <alvherre at 2ndquadrant.com> (Patch: Yes)
    Attachment (logicaldecodng_standby_v5_rebased.tar.gz) at 2020-01-16 04:42:24 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: No)
    Attachment (logicaldecodng_standby_v5.tar.gz) at 2019-12-26 11:05:25 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: No)
    Attachment (logicaldecodng_standby_v4_rebased.tar.gz) at 2019-11-04 11:06:21 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: No)
    Attachment (logicaldecodng_standby_v4.tar.gz) at 2019-10-03 06:35:15 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: No)
    Attachment (logicaldecodng_standby_v3.tar.gz) at 2019-09-30 11:34:57 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: No)
    Attachment (logicaldecodng_standby_v2.tar.gz) at 2019-09-26 09:14:11 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: No)
    Attachment (logicaldecodng_standby_v1_rebased.tar.gz) at 2019-09-13 11:19:54 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: No)
    Attachment (logicaldecodng_standby.tar.gz) at 2019-07-19 05:45:49 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: No)
    Attachment (logical-decoding-on-standby_v12.patch) at 2019-07-10 11:42:35 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: No)
    Attachment (logical-decoding-on-standby_v11.patch) at 2019-07-01 05:34:05 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: No)
    Attachment (logical-decoding-on-standby_v10.patch) at 2019-06-25 10:29:28 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: No)
    Attachment (logical-decoding-on-standby_v9.patch) at 2019-06-24 18:28:50 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: No)
    Attachment (logical-decoding-on-standby_v8.patch) at 2019-06-20 09:58:10 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: No)
    Attachment (logical-decoding-on-standby_v7.patch) at 2019-06-14 11:24:19 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: Yes)
    Attachment (logical-decoding-on-standby_v6.patch) at 2019-06-12 12:00:02 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: Yes)
    Attachment (logical-decoding-on-standby_v5.patch) at 2019-05-27 11:34:44 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: Yes)
    Attachment (handle_wal_level_changes_WIP.patch) at 2019-05-24 15:30:36 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: Yes)
    Attachment (logical-decoding-on-standby_v4_rebased.patch) at 2019-05-22 09:32:10 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: Yes)
    Attachment (logical-decoding-on-standby_v4.patch) at 2019-04-09 16:53:16 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: Yes)
    Attachment (logical-decoding-on-standby_v3.patch) at 2019-04-05 11:38:39 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: Yes)
    Attachment (logical-decoding-on-standby_v2.patch) at 2019-04-03 14:27:33 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: Yes)
    Attachment (0001-Logical-decoding-on-standby_rebased.patch) at 2019-03-04 08:39:52 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: Yes)
    Attachment (index-page-vacuum-xid-horizon-primary.diff) at 2018-12-14 00:55:21 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (logical-decoding-on-standby.diff) at 2018-12-12 20:41:54 from Andres Freund <andres at anarazel.de> (Patch: Yes)
History
When Who What
2023-04-08 16:31:01 Andres Freund (andresfreund) Closed in commitfest 2023-03 with status: Committed
2023-04-08 16:31:01 Andres Freund (andresfreund) Changed committer to andresfreund
2023-01-31 16:20:39 vigneshwaran C (vignesh.postgres) Closed in commitfest 2023-01 with status: Moved to next CF
2023-01-11 06:37:17 Bharath Rupireddy (bharathrupireddy) Added bharathrupireddy as reviewer
2022-12-02 05:19:30 Michael Paquier (michael-kun) Closed in commitfest 2022-11 with status: Moved to next CF
2022-10-07 05:44:29 Michael Paquier (michael-kun) Closed in commitfest 2022-09 with status: Moved to next CF
2022-10-07 05:44:25 Michael Paquier (michael-kun) New status: Needs review
2022-08-02 18:34:30 Jacob Champion (jchampion) Closed in commitfest 2022-07 with status: Moved to next CF
2022-06-30 14:46:00 Bertrand Drouvot (bdrouvot) New status: Waiting on Author
2022-06-30 14:45:18 Bertrand Drouvot (bdrouvot) Changed authors to Bertrand Drouvot (bdrouvot)
2022-06-30 14:45:18 Bertrand Drouvot (bdrouvot) Changed targetversion to 16
2022-06-30 14:45:02 Bertrand Drouvot (bdrouvot) Attached mail thread 20181212204154.nsxf3gzqv3gesl32@alap3.anarazel.de
2022-06-30 14:45:01 Bertrand Drouvot (bdrouvot) Created patch record
Edit