logical decoding and replication of sequences, take 2

Edit

Title

Topic

Server Features

Created

2022-08-18 21:25:18

Last modified

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

Latest email

2024-03-06 17:34:15 (6 months, 1 week 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

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