Re: Slow catchup of 2PC (twophase) transactions on replica in LR

From:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:	Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Cc:	Peter Smith <smithpb2250(at)gmail(dot)com>, "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>, "Zhijie Hou (Fujitsu)" <houzj(dot)fnst(at)fujitsu(dot)com>, "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Vitaly Davydov <v(dot)davydov(at)postgrespro(dot)ru>, Ajin Cherian <itsajin(at)gmail(dot)com>
Subject:	Re: Slow catchup of 2PC (twophase) transactions on replica in LR
Date:	2024-07-24 15:43:43
Message-ID:	1238410.1721835823@sss.pgh.pa.us
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2024-02-22 13:29:43 from Давыдов Виталий <v(dot)davydov(at)postgrespro(dot)ru>  2024-02-23 03:23:49 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>   2024-02-23 17:11:46 from Давыдов Виталий <v(dot)davydov(at)postgrespro(dot)ru>    2024-02-26 13:24:55 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>     2024-02-27 11:19:41 from Давыдов Виталий <v(dot)davydov(at)postgrespro(dot)ru> 📎      2024-02-27 13:00:28 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>       2024-02-27 13:34:47 from Давыдов Виталий <v(dot)davydov(at)postgrespro(dot)ru>        2024-02-29 17:34:42 from Давыдов Виталий <v(dot)davydov(at)postgrespro(dot)ru> 📎         2024-03-05 09:05:40 from Heikki Linnakangas <hlinnaka(at)iki(dot)fi>          2024-03-05 14:29:32 from Давыдов Виталий <v(dot)davydov(at)postgrespro(dot)ru>           2024-03-06 12:25:54 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>           2024-04-04 05:23:15 from Ajin Cherian <itsajin(at)gmail(dot)com> 📎            2024-04-04 05:37:49 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>             2024-04-05 11:29:29 from Ajin Cherian <itsajin(at)gmail(dot)com> 📎              2024-04-10 11:18:26 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>               2024-04-10 14:16:59 from Давыдов Виталий <v(dot)davydov(at)postgrespro(dot)ru>                2024-04-15 15:31:55 from Давыдов Виталий <v(dot)davydov(at)postgrespro(dot)ru>                 2024-04-16 08:12:11 from Ajin Cherian <itsajin(at)gmail(dot)com>                 2024-04-22 08:54:48 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>                  2024-04-22 12:54:10 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> 📎                   2024-04-22 14:22:14 from "Vitaly Davydov" <v(dot)davydov(at)postgrespro(dot)ru>                   2024-04-23 12:15:32 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> 📎                    2024-05-08 00:07:34 from Peter Smith <smithpb2250(at)gmail(dot)com>                     2024-05-08 08:26:42 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> 📎                      2024-05-09 02:14:59 from Peter Smith <smithpb2250(at)gmail(dot)com>                       2024-05-09 08:26:19 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>                      2024-05-09 02:21:24 from Peter Smith <smithpb2250(at)gmail(dot)com>                       2024-05-09 08:54:36 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>                      2024-05-09 06:11:44 from Peter Smith <smithpb2250(at)gmail(dot)com>                       2024-05-09 09:10:53 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>                      2024-05-09 07:28:57 from Peter Smith <smithpb2250(at)gmail(dot)com>                       2024-05-09 09:15:59 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> 📎                        2024-05-13 06:34:35 from Peter Smith <smithpb2250(at)gmail(dot)com>                         2024-05-13 12:25:26 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> 📎                          2024-05-14 04:06:34 from Peter Smith <smithpb2250(at)gmail(dot)com>                           2024-05-14 12:04:46 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>                          2024-05-14 04:18:45 from Peter Smith <smithpb2250(at)gmail(dot)com>                           2024-05-14 12:03:49 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> 📎                            2024-05-15 05:02:36 from Peter Smith <smithpb2250(at)gmail(dot)com>                             2024-05-16 05:02:55 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> 📎                              2024-05-17 02:20:55 from Peter Smith <smithpb2250(at)gmail(dot)com>                               2024-05-17 03:06:34 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> 📎                                2024-05-17 04:08:15 from Peter Smith <smithpb2250(at)gmail(dot)com>                                2024-06-25 08:06:10 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> 📎                                 2024-06-25 09:11:16 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>                            2024-05-15 05:12:50 from Peter Smith <smithpb2250(at)gmail(dot)com>                             2024-05-16 05:04:51 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>                        2024-05-13 06:37:21 from Peter Smith <smithpb2250(at)gmail(dot)com>                         2024-05-13 12:27:49 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>                        2024-05-13 06:40:34 from Peter Smith <smithpb2250(at)gmail(dot)com>                         2024-05-13 12:28:11 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>               2024-04-11 02:07:33 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>               2024-04-15 07:57:49 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> 📎                2024-04-15 09:46:53 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                 2024-04-16 02:18:29 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> 📎                  2024-04-16 06:25:11 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                   2024-04-18 06:26:22 from Ajin Cherian <itsajin(at)gmail(dot)com> 📎                    2024-04-22 07:34:58 from Ajin Cherian <itsajin(at)gmail(dot)com>                     2024-04-22 08:56:42 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> 📎                      2024-07-04 06:55:18 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                       2024-07-04 08:04:47 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> 📎                        2024-07-04 11:31:40 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                         2024-07-05 05:39:05 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> 📎                          2024-07-05 09:08:17 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>                           2024-07-05 14:06:19 from "Vitaly Davydov" <v(dot)davydov(at)postgrespro(dot)ru>                            2024-07-08 07:04:40 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> 📎                             2024-07-08 11:55:01 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                              2024-07-09 05:05:37 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                               2024-07-09 11:49:38 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> 📎                                2024-07-09 12:52:55 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> 📎                                 2024-07-13 10:48:55 from "Zhijie Hou (Fujitsu)" <houzj(dot)fnst(at)fujitsu(dot)com> 📎                                 2024-07-15 11:39:10 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                  2024-07-16 05:17:06 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> 📎                                   2024-07-16 10:02:21 from Peter Smith <smithpb2250(at)gmail(dot)com> 📎                                   2024-07-17 00:58:51 from "Zhijie Hou (Fujitsu)" <houzj(dot)fnst(at)fujitsu(dot)com>                                   2024-07-17 03:31:14 from Peter Smith <smithpb2250(at)gmail(dot)com> 📎                                   2024-07-17 04:28:20 from Peter Smith <smithpb2250(at)gmail(dot)com> 📎                                    2024-07-17 05:13:35 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> 📎                                     2024-07-17 07:53:28 from Peter Smith <smithpb2250(at)gmail(dot)com> 📎                                     2024-07-17 23:24:29 from Peter Smith <smithpb2250(at)gmail(dot)com> 📎                                     2024-07-18 00:09:05 from Peter Smith <smithpb2250(at)gmail(dot)com> 📎                                      2024-07-18 02:10:47 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> 📎                                       2024-07-18 03:22:18 from "Zhijie Hou (Fujitsu)" <houzj(dot)fnst(at)fujitsu(dot)com>                                       2024-07-18 11:42:46 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                                        2024-07-19 02:36:04 from Peter Smith <smithpb2250(at)gmail(dot)com> 📎                                         2024-07-19 05:15:16 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                          2024-07-19 06:24:56 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                        2024-07-19 12:44:55 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                         2024-07-22 02:56:49 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>                                          2024-07-22 06:57:26 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                                           2024-07-22 09:17:44 from Peter Smith <smithpb2250(at)gmail(dot)com> 📎                                            2024-07-23 11:25:07 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                                             2024-07-24 09:26:27 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                              2024-07-24 15:43:43 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                               2024-07-25 03:08:38 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                2024-07-30 10:32:06 from vignesh C <vignesh21(at)gmail(dot)com> 📎                                                 2024-07-30 10:58:17 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                       2024-07-20 16:01:06 from vignesh C <vignesh21(at)gmail(dot)com>                                        2024-07-22 03:15:40 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                              2024-07-09 11:42:01 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>  2024-02-23 04:52:11 from Ajin Cherian <itsajin(at)gmail(dot)com>   2024-02-23 16:29:29 from Давыдов Виталий <v(dot)davydov(at)postgrespro(dot)ru>
Lists:	pgsql-hackers

In response to

• Re: Slow catchup of 2PC (twophase) transactions on replica in LR at 2024-07-24 09:26:27 from Amit Kapila

Responses

• Re: Slow catchup of 2PC (twophase) transactions on replica in LR at 2024-07-25 03:08:38 from Amit Kapila

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Jeremy Schneider	2024-07-24 15:44:42	Re: Built-in CTYPE provider
Previous Message	Tom Lane	2024-07-24 15:39:56	Re: Support prepared statement invalidation when result types change