RE: Data is copied twice when specifying both child and parent table in publication

From:	"wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com>
To:	Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Cc:	"osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>, "shiy(dot)fnst(at)fujitsu(dot)com" <shiy(dot)fnst(at)fujitsu(dot)com>, "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com>, Amit Langote <amitlangote09(at)gmail(dot)com>, Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>, "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Greg Nancarrow <gregn4422(at)gmail(dot)com>, vignesh C <vignesh21(at)gmail(dot)com>
Subject:	RE: Data is copied twice when specifying both child and parent table in publication
Date:	2022-05-18 08:51:26
Message-ID:	OS3PR01MB6275937EAEE44CC137711F489ED19@OS3PR01MB6275.jpnprd01.prod.outlook.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2021-10-15 11:22:50 from "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com> 📎  2021-10-16 06:30:47 from "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com> 📎   2021-10-18 02:57:25 from Greg Nancarrow <gregn4422(at)gmail(dot)com>    2021-10-18 06:00:43 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>     2021-10-18 09:02:35 from Amit Langote <amitlangote09(at)gmail(dot)com>      2021-10-18 09:28:58 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>       2021-10-19 03:15:47 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>        2021-10-19 04:29:25 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>      2021-10-19 02:47:13 from "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com>       2021-10-19 05:37:46 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>        2021-10-28 07:35:07 from "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com> 📎         2021-10-28 08:25:12 from Amit Langote <amitlangote09(at)gmail(dot)com>          2021-11-03 10:13:30 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>           2021-11-04 04:13:45 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>            2021-11-04 06:53:24 from Greg Nancarrow <gregn4422(at)gmail(dot)com>             2021-11-04 08:10:48 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>              2021-11-05 03:20:15 from Greg Nancarrow <gregn4422(at)gmail(dot)com>               2021-11-11 06:52:40 from "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com> 📎                2021-11-11 08:14:26 from Greg Nancarrow <gregn4422(at)gmail(dot)com>                 2021-11-12 04:11:01 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                2021-11-12 04:27:39 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                 2021-11-16 01:56:41 from "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com>                2021-11-29 08:51:35 from "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com> 📎                 2021-12-01 11:15:00 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                  2021-12-01 23:21:39 from Greg Nancarrow <gregn4422(at)gmail(dot)com>                   2021-12-02 02:33:31 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                    2021-12-02 02:48:34 from Greg Nancarrow <gregn4422(at)gmail(dot)com>                     2021-12-02 04:10:54 from Greg Nancarrow <gregn4422(at)gmail(dot)com>                      2021-12-02 04:50:16 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                       2021-12-02 08:54:18 from "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com> 📎                        2021-12-03 05:54:21 from "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com> 📎                         2021-12-07 12:23:00 from vignesh C <vignesh21(at)gmail(dot)com>                          2021-12-08 05:41:45 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                           2021-12-08 06:00:27 from vignesh C <vignesh21(at)gmail(dot)com>                            2021-12-08 06:08:37 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                             2021-12-09 10:51:55 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                              2022-03-10 02:17:32 from "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com>                               2022-04-07 03:08:14 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com> 📎                                2022-04-19 07:04:43 from "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com>                                 2022-04-19 08:53:09 from "shiy(dot)fnst(at)fujitsu(dot)com" <shiy(dot)fnst(at)fujitsu(dot)com> 📎                                  2022-04-21 03:05:13 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com> 📎                                  2022-04-21 09:41:00 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                   2022-04-24 06:16:04 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com> 📎                                    2022-04-25 01:23:42 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com>                                    2022-04-28 01:22:13 from "shiy(dot)fnst(at)fujitsu(dot)com" <shiy(dot)fnst(at)fujitsu(dot)com>                                     2022-05-09 01:51:09 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com> 📎                                      2022-05-11 02:32:36 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>                                       2022-05-12 01:47:32 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>                                        2022-05-13 02:02:25 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com> 📎                                         2022-05-13 05:58:31 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                          2022-05-13 09:41:42 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com> 📎                                           2022-05-13 14:57:08 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>                                            2022-05-18 08:39:15 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com>                                           2022-05-17 13:02:57 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                            2022-05-18 08:37:56 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com> 📎                                             2022-05-18 08:51:26 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com> 📎                                              2022-07-01 09:46:43 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com> 📎                                               2022-07-14 04:45:35 from Peter Smith <smithpb2250(at)gmail(dot)com>                                                2022-07-21 10:07:36 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com> 📎                                                 2022-07-28 09:17:03 from Peter Smith <smithpb2250(at)gmail(dot)com>                                                  2022-08-04 11:26:18 from "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com>                                                  2022-08-05 09:06:49 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com> 📎                                                   2022-08-09 07:14:54 from Peter Smith <smithpb2250(at)gmail(dot)com>                                                    2022-08-30 07:43:06 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com> 📎                                                     2022-09-19 06:51:31 from Peter Smith <smithpb2250(at)gmail(dot)com>                                                      2022-09-20 06:17:48 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com> 📎                                                       2022-09-26 02:31:11 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>                                                        2022-09-26 04:44:00 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com> 📎                                                         2022-09-27 08:44:58 from Peter Smith <smithpb2250(at)gmail(dot)com>                                                          2022-09-28 08:35:33 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com> 📎                                                           2022-10-05 03:17:35 from Peter Smith <smithpb2250(at)gmail(dot)com>                                                            2022-10-17 05:49:23 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com> 📎                                                             2022-10-21 08:52:13 from Peter Smith <smithpb2250(at)gmail(dot)com>                                                              2022-11-11 05:43:10 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com> 📎                                                               2022-11-13 16:55:48 from vignesh C <vignesh21(at)gmail(dot)com>                                                                2022-11-16 08:58:31 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com> 📎                                                                 2022-11-17 05:57:58 from vignesh C <vignesh21(at)gmail(dot)com>                                                                  2022-11-17 07:43:38 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com>                                                                 2023-02-07 20:28:34 from Andres Freund <andres(at)anarazel(dot)de>                                                                  2023-02-08 03:51:08 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com> 📎                                                                   2023-03-16 12:25:22 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                                    2023-03-17 06:28:00 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com> 📎                                                                     2023-03-17 12:07:18 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                                      2023-03-20 00:53:56 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com> 📎                                                                       2023-03-20 13:17:52 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>                                                                        2023-03-21 07:42:11 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com>                                                                     2023-03-17 23:36:53 from Jacob Champion <jchampion(at)timescale(dot)com>                                                                      2023-03-18 04:44:56 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                                       2023-03-20 17:52:46 from Jacob Champion <jchampion(at)timescale(dot)com>                                                                        2023-03-21 06:21:51 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                                         2023-03-27 23:01:59 from Jacob Champion <jchampion(at)timescale(dot)com>                                                                          2023-03-28 09:59:49 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com> 📎                                                                           2023-03-28 10:09:27 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com> 📎                                                                            2023-03-29 02:14:17 from Peter Smith <smithpb2250(at)gmail(dot)com>                                                                             2023-03-29 04:21:30 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                                           2023-03-28 17:44:28 from Jacob Champion <jchampion(at)timescale(dot)com>                                                                            2023-03-29 08:59:52 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                                             2023-03-30 18:15:46 from Jacob Champion <jchampion(at)timescale(dot)com> 📎                                                                              2023-03-31 03:01:57 from Peter Smith <smithpb2250(at)gmail(dot)com>                                                                               2023-03-31 23:04:37 from Jacob Champion <jchampion(at)timescale(dot)com>                                                                              2023-03-31 10:04:10 from "shiy(dot)fnst(at)fujitsu(dot)com" <shiy(dot)fnst(at)fujitsu(dot)com>                                                                               2023-03-31 23:05:37 from Jacob Champion <jchampion(at)timescale(dot)com>                                                                      2023-03-21 07:40:16 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com>                                                                     2023-03-20 07:32:15 from Peter Smith <smithpb2250(at)gmail(dot)com>                                                                      2023-03-20 08:53:48 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                                      2023-03-20 10:14:49 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                                                                       2023-03-21 07:40:00 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com> 📎                                                                        2023-03-22 04:50:07 from Peter Smith <smithpb2250(at)gmail(dot)com>                                                                         2023-03-22 10:07:49 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com> 📎                                                                          2023-03-23 04:26:44 from Peter Smith <smithpb2250(at)gmail(dot)com>                                                                           2023-03-23 06:51:20 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                                            2023-03-23 22:16:25 from Peter Smith <smithpb2250(at)gmail(dot)com>                                                                           2023-03-23 09:11:29 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com> 📎                                                                            2023-03-24 01:48:47 from Peter Smith <smithpb2250(at)gmail(dot)com>                                                                             2023-03-24 06:16:53 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                                              2023-03-24 09:06:45 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com> 📎                                                                               2023-03-25 10:51:22 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                                                                                2023-03-27 01:33:25 from Peter Smith <smithpb2250(at)gmail(dot)com>                                                                                 2023-03-27 03:31:37 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                                                  2023-03-27 05:18:07 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com> 📎                                                                                   2023-03-27 07:56:09 from Peter Smith <smithpb2250(at)gmail(dot)com>                                                                             2023-03-24 09:06:48 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com>                                                                            2023-03-24 02:13:56 from Peter Smith <smithpb2250(at)gmail(dot)com>                                                                             2023-03-24 06:43:32 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com>                                                                        2023-03-22 06:31:50 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>                                                                         2023-03-22 10:09:05 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com>                                                                      2023-03-21 07:41:04 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com>                                                             2022-10-21 09:01:54 from Peter Smith <smithpb2250(at)gmail(dot)com>                                                              2022-11-11 05:44:53 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com>                                                             2022-11-03 23:34:43 from Ian Lawrence Barwick <barwick(at)gmail(dot)com>                                                             2022-11-08 04:12:00 from "Takamichi Osumi (Fujitsu)" <osumi(dot)takamichi(at)fujitsu(dot)com>                                                              2022-11-11 05:45:40 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com>                                                           2022-10-05 15:04:50 from "osumi(dot)takamichi(at)fujitsu(dot)com" <osumi(dot)takamichi(at)fujitsu(dot)com>                                                            2022-10-17 05:52:32 from "wangw(dot)fnst(at)fujitsu(dot)com" <wangw(dot)fnst(at)fujitsu(dot)com>                                                   2022-08-09 23:45:25 from Peter Smith <smithpb2250(at)gmail(dot)com>                                                    2022-08-30 02:24:10 from "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com>                  2021-12-02 03:30:37 from Amit Langote <amitlangote09(at)gmail(dot)com>       2021-10-22 02:01:24 from "shiy(dot)fnst(at)fujitsu(dot)com" <shiy(dot)fnst(at)fujitsu(dot)com>     2021-10-20 07:14:07 from Greg Nancarrow <gregn4422(at)gmail(dot)com>      2021-10-20 08:02:02 from Dilip Kumar <dilipbalaut(at)gmail(dot)com>       2021-10-20 08:59:22 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>        2021-10-20 09:33:17 from Greg Nancarrow <gregn4422(at)gmail(dot)com>         2021-10-20 10:19:46 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>          2021-10-20 13:40:53 from Greg Nancarrow <gregn4422(at)gmail(dot)com>           2021-10-21 03:56:15 from Peter Smith <smithpb2250(at)gmail(dot)com>            2021-10-21 05:57:48 from Greg Nancarrow <gregn4422(at)gmail(dot)com>           2021-10-21 09:45:35 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>       2021-10-20 09:00:18 from Greg Nancarrow <gregn4422(at)gmail(dot)com>   2021-10-18 08:46:13 from "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com> 📎
Lists:	pgsql-hackers

Attachment	Content-Type	Size
HEAD_v5-0001-Fix-data-replicated-twice-when-specifying-PUBLISH.patch	application/octet-stream	13.1 KB
REL14_v5-0001-Fix-data-replicated-twice-when-specifying-PUBLISH_patch	application/octet-stream	5.4 KB

In response to

• RE: Data is copied twice when specifying both child and parent table in publication at 2022-05-18 08:37:56 from wangw.fnst@fujitsu.com

Responses

• RE: Data is copied twice when specifying both child and parent table in publication at 2022-07-01 09:46:43 from wangw.fnst@fujitsu.com

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Alvaro Herrera	2022-05-18 08:54:58	Re: Avoid unecessary MemSet call (src/backend/utils/cache/relcache.c)
Previous Message	wangw.fnst@fujitsu.com	2022-05-18 08:39:15	RE: Data is copied twice when specifying both child and parent table in publication