logical decoding and replication of sequences, take 2

Edit

ID 3823

Title logical decoding and replication of sequences, take 2

Topic Server Features

Created 2022-08-18 21:25:18

Last modified 2024-06-21 16:12:39 (4 months, 4 weeks ago)

Latest email 2024-03-06 17:34:15 (8 months, 2 weeks ago)

Status

2024-07: Withdrawn

2024-03: Moved to next CF

2024-01: Moved to next CF

2023-11: Moved to next CF

2023-09: Moved to next CF

2023-07: Moved to next CF

2023-03: Moved to next CF

2023-01: Moved to next CF

2022-11: Moved to next CF

2022-09: Moved to next CF

Target version

Authors Tomas Vondra (fuzzycz)

Reviewers Dilip Kumar (dilip.kumar), Peter Eisentraut (petere), Ashutosh Bapat (ashutoshbapat)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/3823
git checkout commitfest/cf/3823

Emails

logical decoding and replication of sequences: First at 2021-06-07 22:28:22 by Tomas Vondra <tomas.vondra at enterprisedb.com>
Latest at 2022-08-29 21:42:02 by Thomas Munro <thomas.munro at gmail.com>
Latest attachment (v2-0001-Fix-cache-invalidation-in-rare-recovery_prefetch-.patch) at 2022-08-29 21:42:02 from Thomas Munro <thomas.munro at gmail.com>
    Attachment (v2-0001-Fix-cache-invalidation-in-rare-recovery_prefetch-.patch) at 2022-08-29 21:42:02 from Thomas Munro <thomas.munro at gmail.com> (Patch: Yes)
    Attachment (0001-Fix-cache-invalidation-in-rare-recovery_prefetch-cas.patch) at 2022-08-29 10:21:30 from Thomas Munro <thomas.munro at gmail.com> (Patch: Yes)
    Attachment (0001-WIP-Fix-XLogPageRead-cache-invalidation.patch) at 2022-08-08 06:15:46 from Thomas Munro <thomas.munro at gmail.com> (Patch: Yes)
    Attachment (promote-invalid-magic-panic-v0.patch) at 2022-08-07 00:36:27 from Noah Misch <noah at leadboat.com> (Patch: Yes)
    Attachment (0001-Intorduce-new-field-ReplicationSlotPersistentData.no.patch) at 2022-05-25 20:42:29 from Zheng Li <zhengli10 at gmail.com> (Patch: Yes)
    Attachment (decoding-sequences-tracking-20220407.patch) at 2022-04-07 18:34:50 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-rework-sequence-decoding.patch) at 2022-04-06 14:13:52 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (vglobal-0001-WIP-sequence-reworks.patch) at 2022-04-03 21:40:43 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (isolation-tests.patch) at 2022-04-02 00:17:11 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (sequences-tablesync-fix.patch) at 2022-03-25 16:50:49 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Removed-unused-parameter-from-ObjectsInPublicationTo.patch) at 2022-03-25 14:34:57 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (tab_completion.patch) at 2022-03-25 07:00:13 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (0001-Add-support-for-decoding-sequences-to-built-20220323.patch) at 2022-03-23 22:30:06 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Add-support-for-decoding-sequences-to-built-20220320.patch) at 2022-03-20 22:55:37 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Add-support-for-decoding-sequences-to-built-20220313.patch) at 2022-03-14 00:46:03 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-fixup-Add-support-for-decoding-sequences-to-built-in.patch) at 2022-03-13 06:45:44 from Peter Eisentraut <peter.eisentraut at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Add-support-for-decoding-sequences-to-built-20220310.patch) at 2022-03-10 22:49:35 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-fixup-Add-support-for-decoding-sequences-to-built-in.patch) at 2022-03-10 11:07:05 from Peter Eisentraut <peter.eisentraut at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Add-support-for-decoding-sequences-to-built-20220222.patch) at 2022-02-22 23:24:30 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Add-support-for-decoding-sequences-to-built-20220213.patch) at 2022-02-13 13:10:25 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Add-support-for-decoding-sequences-to-buil-20220212b.patch) at 2022-02-12 19:58:53 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Add-support-for-decoding-sequences-to-built-20220212.patch) at 2022-02-12 00:34:33 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Add-support-for-decoding-sequences-to-test_-20220210.patch) at 2022-02-10 18:17:20 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Logical-decoding-of-sequences-20220128.patch) at 2022-01-28 00:25:24 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-fixup-Change-skip-sequences-to-false-by-default.patch) at 2022-01-27 16:05:59 from Peter Eisentraut <peter.eisentraut at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Logical-decoding-of-sequences-20220127.patch) at 2022-01-26 23:32:11 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Logical-decoding-of-sequences-20220126.patch) at 2022-01-26 02:16:57 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-WAL-log-individual-sequence-fetches-20211222.patch) at 2021-12-22 15:40:17 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0003-Add-support-for-decoding-sequences-to-built-20211214.patch) at 2021-12-14 01:31:45 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Logical-decoding-of-sequences-20211208.patch) at 2021-12-08 00:23:45 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Whitespace-fixes.patch) at 2021-12-07 14:38:50 from Peter Eisentraut <peter.eisentraut at enterprisedb.com> (Patch: Yes)
    Attachment (0004-Add-support-for-decoding-sequences-to-built-20211121.patch) at 2021-11-22 00:47:28 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0004-Add-support-for-decoding-sequences-to-built-20211118.patch) at 2021-11-19 19:54:46 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Logical-decoding-of-sequences-20210924.patch) at 2021-09-24 19:16:20 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Logical-decoding-replication-of-sequences-20210729.patch) at 2021-07-30 18:26:50 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Logical-decoding-replication-of-sequences-20210720.patch) at 2021-07-20 21:41:20 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Logical-decoding-replication-of-sequences-20210623.patch) at 2021-06-23 14:25:10 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Logical-decoding-replication-of-sequences-20210613.patch) at 2021-06-13 21:15:07 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (sequence-decoding-20210608.patch) at 2021-06-07 22:28:22 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
logical decoding and replication of sequences, take 2: First at 2022-08-18 21:10:39 by Tomas Vondra <tomas.vondra at enterprisedb.com>
Latest at 2024-03-06 17:34:15 by Tomas Vondra <tomas.vondra at enterprisedb.com>
Latest attachment (v20240111-0001-Logical-decoding-of-sequences.patch) at 2024-01-11 16:26:56 from Tomas Vondra <tomas.vondra at enterprisedb.com>
    Attachment (v20240111-0001-Logical-decoding-of-sequences.patch) at 2024-01-11 16:26:56 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (sequence_clean_elog.txt) at 2023-12-14 15:44:23 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (add_relfilenode_before_full.txt) at 2023-12-14 09:14:56 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (add_elog.txt) at 2023-12-14 03:44:22 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (alter-sequence-master.perf.gz) at 2023-12-05 16:53:37 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: No)
    Attachment (sequence-scripts.tgz) at 2023-12-03 17:52:12 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: No)
    Attachment (one_client.sh) at 2023-12-03 12:55:56 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: No)
    Attachment (scripts.tgz) at 2023-12-02 00:10:57 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: No)
    Attachment (perf_results.txt) at 2023-12-01 11:08:16 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: No)
    Attachment (v20231128-0001-Logical-decoding-of-sequences.patch) at 2023-11-29 13:28:47 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (v20231128-0001-Logical-decoding-of-sequences.patch) at 2023-11-28 21:29:54 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (v20231127-3-0001-Logical-decoding-of-sequences.patch) at 2023-11-27 18:15:55 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (v202311272-0001-Logical-decoding-of-sequences.txt) at 2023-11-27 12:08:24 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v20231127-0001-Logical-decoding-of-sequences.patch) at 2023-11-27 01:11:14 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Logical-decoding-of-sequences-20231102.patch) at 2023-11-02 15:30:10 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Logical-decoding-of-sequences-20231012.patch) at 2023-10-12 15:05:30 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (bt.txt) at 2023-09-15 03:11:16 from "Zhijie Hou (Fujitsu)" <houzj.fnst at fujitsu.com> (Patch: No)
    Attachment (0001-Logical-decoding-of-sequences-20230816.patch) at 2023-08-16 14:26:46 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Logical-decoding-of-sequences-20230730.patch) at 2023-07-30 00:00:31 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Logical-decoding-of-sequences-20230729.patch) at 2023-07-29 13:03:31 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Logical-decoding-of-sequences-20230726.patch) at 2023-07-26 15:18:35 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Logical-decoding-of-sequences-20230725b.patch) at 2023-07-25 21:12:53 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Logical-decoding-of-sequences-20230725.patch) at 2023-07-25 16:24:49 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Make-test_decoding-ddl.out-shorter-20230724.patch) at 2023-07-24 14:52:05 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Make-test_decoding-ddl.out-shorter-20230720.patch) at 2023-07-20 14:51:59 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0007-Edits-on-0002-patch-20230720.patch) at 2023-07-20 07:24:21 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0001-Make-test_decoding-ddl.out-shorter-20230719b.patch) at 2023-07-19 21:01:04 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Make-test_decoding-ddl.out-shorter-20230719.patch) at 2023-07-19 10:53:36 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Make-test_decoding-ddl.out-shorter-20230715.patch) at 2023-07-15 15:08:20 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Make-test_decoding-ddl.out-shorter-20230714.patch) at 2023-07-14 10:40:00 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Make-test_decoding-ddl.out-shorter-20230712.patch) at 2023-07-12 19:05:15 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0005-add-interlock-with-ALTER-SEQUENCE-20230613.patch) at 2023-06-13 13:34:05 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0001-Logical-decoding-of-sequences-20230405.patch) at 2023-04-05 21:26:33 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-make-test_decoding-ddl.out-shorter.patch.txt) at 2023-04-05 10:39:53 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (0001-Logical-decoding-of-sequences-20230402.patch) at 2023-04-02 17:46:57 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Logical-decoding-of-sequences-20230323.patch) at 2023-03-23 22:25:38 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Logical-decoding-of-sequences-20230316.patch) at 2023-03-16 16:25:45 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Logical-decoding-of-sequences-20230315.patch) at 2023-03-15 12:51:32 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Logical-decoding-of-sequences-20230228.patch) at 2023-02-28 18:01:41 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Fix-snapshot-handling-in-logicalmsg_decode-20230216.patch) at 2023-02-16 15:50:30 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Fix-snapshot-handling-in-logicalmsg_decode-20230116.patch) at 2023-01-15 23:18:54 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Fix-snapshot-handling-in-logicalmsg_decode-20230115.patch) at 2023-01-14 23:39:06 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Fix-snapshot-handling-in-logicalmsg_decode-20230110.patch) at 2023-01-10 18:32:12 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (logical-msg-fix.patch) at 2022-11-17 21:13:23 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (decoding-sequences-tracking-20221112.patch) at 2022-11-11 22:49:07 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (decoding-sequences-tracking-20220818.patch) at 2022-08-18 21:10:39 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)

History

When	Who	What
2024-06-21 16:12:39	Tomas Vondra (fuzzycz)	Closed in commitfest 2024-07 with status: Withdrawn
2024-04-08 07:20:12	Andrey Borodin (x4m)	Closed in commitfest 2024-03 with status: Moved to next CF
2024-04-08 07:20:07	Andrey Borodin (x4m)	New status: Needs review
2024-02-01 15:28:49	vigneshwaran C (vignesh.postgres)	Closed in commitfest 2024-01 with status: Moved to next CF
2024-01-16 11:21:59	Peter Eisentraut (petere)	New status: Waiting on Author
2023-12-07 04:37:27	Dilip Kumar (dilip.kumar)	Added dilip.kumar as reviewer
2023-12-01 08:07:13	Peter Eisentraut (petere)	Closed in commitfest 2023-11 with status: Moved to next CF
2023-10-02 11:06:03	Peter Eisentraut (petere)	Closed in commitfest 2023-09 with status: Moved to next CF
2023-08-25 20:24:09	Peter Eisentraut (petere)	New status: Needs review
2023-08-05 18:21:25	Daniel Gustafsson (d_gustafsson)	Closed in commitfest 2023-07 with status: Moved to next CF
2023-07-06 08:25:00	Peter Eisentraut (petere)	New status: Waiting on Author
2023-05-19 03:50:20	Ashutosh Bapat (ashutoshbapat)	Added ashutoshbapat as reviewer
2023-04-19 14:18:33	Peter Eisentraut (petere)	Added petere as reviewer
2023-04-19 14:18:32	Peter Eisentraut (petere)	Removed petere from committers
2023-04-19 14:18:30	Peter Eisentraut (petere)	Added petere as committer
2023-04-09 03:16:11	Greg Stark (stark)	Closed in commitfest 2023-03 with status: Moved to next CF
2023-01-31 02:37:28	vigneshwaran C (vignesh.postgres)	Closed in commitfest 2023-01 with status: Moved to next CF
2022-12-08 10:15:48	Ian Barwick (barwick)	Closed in commitfest 2022-11 with status: Moved to next CF
2022-12-08 10:15:10	Ian Barwick (barwick)	New status: Needs review
2022-10-12 08:36:11	Michael Paquier (michael-kun)	Closed in commitfest 2022-09 with status: Moved to next CF
2022-10-12 08:36:07	Michael Paquier (michael-kun)	New status: Waiting on Author
2022-09-18 05:17:19	Justin Pryzby (justinpryzby)	Changed authors to Tomas Vondra (fuzzycz)
2022-08-18 21:26:02	Tomas Vondra (fuzzycz)	Attached mail thread d045f3c2-6cfb-06d3-5540-e63c320df8bc@enterprisedb.com
2022-08-18 21:25:18	Tomas Vondra (fuzzycz)	Attached mail thread 76e5fcd8-8072-8ea2-d361-2e811941000c@enterprisedb.com
2022-08-18 21:25:18	Tomas Vondra (fuzzycz)	Created patch record

Edit