Minimal logical decoding on standbys

Edit
ID 2283
Title Minimal logical decoding on standbys
Topic Replication & Recovery
Created 2019-09-13 11:11:00
Last modified 2020-06-11 04:24:36 (4 years, 4 months ago)
Latest email 2023-04-08 17:12:16 (1 year, 6 months ago)
Status
2020-07: Withdrawn
2020-03: Moved to next CF
2020-01: Moved to next CF
2019-11: Moved to next CF
Target version
Authors Amit Khandekar (amitdkhan)
Reviewers Rahila Syed (rahila.syed)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/2283
git checkout commitfest/cf/2283
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-06-11 04:24:36 Amit Khandekar (amitdkhan) Closed in commitfest 2020-07 with status: Withdrawn
2020-04-08 15:34:52 David Steele (dsteele) Closed in commitfest 2020-03 with status: Moved to next CF
2020-02-01 12:54:30 Tomas Vondra (fuzzycz) Closed in commitfest 2020-01 with status: Moved to next CF
2019-11-29 06:37:21 Michael Paquier (michael-kun) Closed in commitfest 2019-11 with status: Moved to next CF
2019-11-04 09:41:43 Rahila Syed (rahila.syed) Added rahila.syed as reviewer
2019-11-04 09:41:34 Rahila Syed (rahila.syed) Removed rahila.syed from reviewers
2019-11-04 09:41:30 Rahila Syed (rahila.syed) Added rahila.syed as reviewer
2019-10-14 09:36:04 nil socket (nilsocket.gmail.com) Posted comment with messageid <157104576440.21777.5948006692875976130.pgcf@coridan.postgresql.org>
2019-09-13 11:13:42 Amit Khandekar (amitdkhan) Changed authors to Amit Khandekar (amitdkhan)
2019-09-13 11:11:00 Amit Khandekar (amitdkhan) Attached mail thread 20181212204154.nsxf3gzqv3gesl32@alap3.anarazel.de
2019-09-13 11:11:00 Amit Khandekar (amitdkhan) Created patch record
Edit