Minimal logical decoding on standbys

Edit
ID 2683
Title Minimal logical decoding on standbys
Topic Replication & Recovery
Created 2020-08-16 16:40:02
Last modified 2020-09-17 05:57:41 (4 years, 2 months ago)
Latest email 2023-04-08 17:12:16 (1 year, 7 months ago)
Status
2020-09: Returned with feedback
Target version
Authors Andres Freund (andresfreund), Craig Ringer (ringerc), Amit Khandekar (amitdkhan), Ibrar Ahmed (ibrar)
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/2683
git checkout commitfest/cf/2683
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
2020-09-17 05:57:41 Michael Paquier (michael-kun) Closed in commitfest 2020-09 with status: Returned with feedback
2020-08-16 18:28:07 Ibrar Ahmed (ibrar) New status: Waiting on Author
2020-08-16 16:41:25 Ibrar Ahmed (ibrar) Changed authors to Andres Freund (andresfreund), Craig Ringer (ringerc), Amit Khandekar (amitdkhan), Ibrar Ahmed (ibrar)
2020-08-16 16:40:02 Ibrar Ahmed (ibrar) Attached mail thread 20181212204154.nsxf3gzqv3gesl32@alap3.anarazel.de
2020-08-16 16:40:02 Ibrar Ahmed (ibrar) Created patch record
Edit