Re: logical replication empty transactions

From:	Ajin Cherian <itsajin(at)gmail(dot)com>
To:	"shiy(dot)fnst(at)fujitsu(dot)com" <shiy(dot)fnst(at)fujitsu(dot)com>
Cc:	Peter Smith <smithpb2250(at)gmail(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>, vignesh C <vignesh21(at)gmail(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>, Rahila Syed <rahila(dot)syed(at)2ndquadrant(dot)com>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Craig Ringer <craig(at)2ndquadrant(dot)com>
Subject:	Re: logical replication empty transactions
Date:	2022-03-04 01:41:16
Message-ID:	CAFPTHDaqjNbKa=QnwuPUneR_Atq2v_AEYTA43RBcx+9jfZMmJA@mail.gmail.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2019-10-22 00:20:21 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>  2019-11-09 01:58:50 from Euler Taveira <euler(at)timbira(dot)com(dot)br> 📎   2019-11-09 21:28:15 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>   2020-03-02 03:30:51 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>    2020-03-02 11:26:40 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>     2020-03-03 04:05:18 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>      2020-03-03 08:24:24 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>       2020-03-03 08:47:14 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>        2020-03-03 10:04:01 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>       2020-03-04 01:47:22 from Euler Taveira <euler(dot)taveira(at)2ndquadrant(dot)com>        2020-03-04 03:42:43 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>         2020-03-04 04:21:44 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>          2020-03-04 05:19:54 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>           2020-03-04 05:45:52 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>            2020-03-04 10:17:10 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>             2020-03-04 10:33:54 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>              2020-03-05 08:45:34 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>               2020-03-05 12:59:11 from Euler Taveira <euler(dot)taveira(at)2ndquadrant(dot)com>     2020-03-06 05:53:02 from Craig Ringer <craig(at)2ndquadrant(dot)com>      2020-03-09 18:30:18 from Andres Freund <andres(at)anarazel(dot)de>       2020-03-13 06:39:43 from Craig Ringer <craig(at)2ndquadrant(dot)com>        2020-07-24 07:40:17 from Ajin Cherian <itsajin(at)gmail(dot)com>         2020-07-24 08:13:26 from Ajin Cherian <itsajin(at)gmail(dot)com>        2020-07-29 14:38:06 from Rahila Syed <rahila(dot)syed(at)2ndquadrant(dot)com>         2020-09-17 05:29:28 from Michael Paquier <michael(at)paquier(dot)xyz>          2021-04-15 03:29:48 from Ajin Cherian <itsajin(at)gmail(dot)com> 📎           2021-04-15 06:38:40 from Ajin Cherian <itsajin(at)gmail(dot)com> 📎            2021-04-19 08:22:22 from Peter Smith <smithpb2250(at)gmail(dot)com>             2021-04-23 05:46:06 from Ajin Cherian <itsajin(at)gmail(dot)com> 📎              2021-04-23 05:57:34 from Ajin Cherian <itsajin(at)gmail(dot)com>              2021-04-26 06:28:54 from Peter Smith <smithpb2250(at)gmail(dot)com>               2021-04-27 03:49:58 from Ajin Cherian <itsajin(at)gmail(dot)com> 📎                2021-05-25 13:06:28 from Ajin Cherian <itsajin(at)gmail(dot)com> 📎                 2021-05-27 10:58:47 from vignesh C <vignesh21(at)gmail(dot)com>                  2021-07-14 12:30:17 from Ajin Cherian <itsajin(at)gmail(dot)com> 📎                   2021-07-15 05:50:45 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>                    2021-07-19 05:24:39 from Peter Smith <smithpb2250(at)gmail(dot)com>                     2021-07-21 10:58:45 from Ajin Cherian <itsajin(at)gmail(dot)com> 📎                    2021-07-21 11:00:14 from Ajin Cherian <itsajin(at)gmail(dot)com>                     2021-07-22 08:11:08 from Peter Smith <smithpb2250(at)gmail(dot)com>                      2021-07-22 13:36:39 from Ajin Cherian <itsajin(at)gmail(dot)com> 📎                       2021-07-23 00:13:00 from Peter Smith <smithpb2250(at)gmail(dot)com>                        2021-07-23 05:42:09 from Ajin Cherian <itsajin(at)gmail(dot)com>                         2021-07-23 09:38:07 from Peter Smith <smithpb2250(at)gmail(dot)com>                          2021-07-23 10:09:33 from Ajin Cherian <itsajin(at)gmail(dot)com> 📎                           2021-07-26 01:20:23 from Peter Smith <smithpb2250(at)gmail(dot)com>                           2021-07-26 02:03:59 from Greg Nancarrow <gregn4422(at)gmail(dot)com>                           2021-07-26 04:12:16 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>                           2021-07-30 05:40:52 from Peter Smith <smithpb2250(at)gmail(dot)com> 📎                           2021-08-02 09:20:27 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                            2021-08-06 14:01:42 from Ajin Cherian <itsajin(at)gmail(dot)com> 📎                             2021-08-09 07:05:08 from Peter Smith <smithpb2250(at)gmail(dot)com>                            2021-08-13 11:00:58 from Ajin Cherian <itsajin(at)gmail(dot)com> 📎                             2021-08-16 06:43:51 from Peter Smith <smithpb2250(at)gmail(dot)com>                              2021-08-17 12:58:42 from Ajin Cherian <itsajin(at)gmail(dot)com> 📎                               2021-08-25 07:15:00 from Peter Smith <smithpb2250(at)gmail(dot)com>                                2021-09-01 10:57:39 from Ajin Cherian <itsajin(at)gmail(dot)com> 📎                                 2022-01-11 09:43:23 from Ajin Cherian <itsajin(at)gmail(dot)com> 📎                                  2022-01-26 09:32:54 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>                                   2022-01-27 12:56:41 from Ajin Cherian <itsajin(at)gmail(dot)com> 📎                                    2022-01-30 08:04:48 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>                                     2022-01-31 12:48:47 from Ajin Cherian <itsajin(at)gmail(dot)com> 📎                                      2022-02-07 23:57:02 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>                                       2022-02-18 09:17:33 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                        2022-02-18 09:36:02 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>                                         2022-02-18 10:27:22 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                          2022-02-25 11:19:02 from Ajin Cherian <itsajin(at)gmail(dot)com> 📎                                      2022-02-16 03:15:20 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>                                       2022-02-17 11:23:38 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                       2022-02-18 08:21:49 from Ajin Cherian <itsajin(at)gmail(dot)com>                                      2022-02-17 10:42:24 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                       2022-02-18 09:10:08 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                       2022-02-23 02:58:14 from Ajin Cherian <itsajin(at)gmail(dot)com> 📎                                        2022-02-23 06:24:28 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com>                                        2022-02-25 10:16:30 from Peter Smith <smithpb2250(at)gmail(dot)com>                                         2022-03-01 05:02:17 from Ajin Cherian <itsajin(at)gmail(dot)com> 📎                                          2022-03-02 02:00:55 from "shiy(dot)fnst(at)fujitsu(dot)com" <shiy(dot)fnst(at)fujitsu(dot)com>                                           2022-03-02 13:40:00 from Ajin Cherian <itsajin(at)gmail(dot)com>                                           2022-03-03 03:36:05 from Ajin Cherian <itsajin(at)gmail(dot)com> 📎                                            2022-03-04 01:41:16 from Ajin Cherian <itsajin(at)gmail(dot)com> 📎                                             2022-03-04 07:27:25 from Peter Smith <smithpb2250(at)gmail(dot)com>                                             2022-03-07 08:50:42 from "shiy(dot)fnst(at)fujitsu(dot)com" <shiy(dot)fnst(at)fujitsu(dot)com>                                              2022-03-07 12:44:14 from Ajin Cherian <itsajin(at)gmail(dot)com> 📎                                               2022-03-16 07:03:24 from Ajin Cherian <itsajin(at)gmail(dot)com> 📎                                                2022-03-17 11:43:11 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                 2022-03-19 03:40:34 from Ajin Cherian <itsajin(at)gmail(dot)com> 📎                                                  2022-03-21 10:01:11 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                                                   2022-03-22 00:48:20 from "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com> 📎                                                    2022-03-22 01:55:31 from "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com> 📎                                                     2022-03-22 11:50:05 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                                                      2022-03-24 03:19:18 from "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com> 📎                                                       2022-03-24 03:33:23 from "shiy(dot)fnst(at)fujitsu(dot)com" <shiy(dot)fnst(at)fujitsu(dot)com> 📎                                                       2022-03-25 00:30:30 from "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com>                                                        2022-03-25 07:20:38 from "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com> 📎                                                         2022-03-28 07:07:59 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                          2022-03-28 12:21:42 from "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com> 📎                                                           2022-03-29 07:20:15 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                                            2022-03-29 08:35:11 from "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com> 📎                                                             2022-03-29 09:11:54 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                              2022-03-29 09:15:05 from "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com> 📎                                                               2022-03-29 09:35:28 from "shiy(dot)fnst(at)fujitsu(dot)com" <shiy(dot)fnst(at)fujitsu(dot)com> 📎                                                               2022-03-30 01:44:37 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                                                2022-03-30 08:30:01 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                      2022-02-22 04:19:01 from Peter Smith <smithpb2250(at)gmail(dot)com>                                  2022-01-26 13:16:45 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>                                   2022-01-27 13:04:04 from Ajin Cherian <itsajin(at)gmail(dot)com>                       2021-07-23 00:26:16 from Greg Nancarrow <gregn4422(at)gmail(dot)com>                        2021-07-23 05:41:07 from Ajin Cherian <itsajin(at)gmail(dot)com> 📎
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v23-0001-Skip-empty-transactions-for-logical-replication.patch	application/octet-stream	18.7 KB
v23-0002-Skip-empty-streamed-transactions-for-logical-rep.patch	application/octet-stream	11.0 KB

In response to

• Re: logical replication empty transactions at 2022-03-03 03:36:05 from Ajin Cherian

Responses

• Re: logical replication empty transactions at 2022-03-04 07:27:25 from Peter Smith
• RE: logical replication empty transactions at 2022-03-07 08:50:42 from shiy.fnst@fujitsu.com

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Noah Misch	2022-03-04 01:41:39	Re: XLogReadRecord() error in XlogReadTwoPhaseData()
Previous Message	Kyotaro Horiguchi	2022-03-04 01:32:27	Re: pg_stop_backup() v2 incorrectly marked as proretset