Minimal logical decoding on standbys

Edit
Title Minimal logical decoding on standbys
Topic Replication & Recovery
Created 2020-08-16 16:40:02
Last modified 2020-09-17 05:57:41 (3 years, 7 months ago)
Latest email 2023-04-08 17:12:16 (1 year 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
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