Re: Single transaction in the tablesync worker?
От
Peter Smith
Тема
Re: Single transaction in the tablesync worker?
Дата
Msg-id
CAHut+PsvOfvKSxHVj2ZLGZp-qEU4SDG2wy9TY-1uJQZ-BMfapA@mail.gmail.com
Ответ на
Re: Single transaction in the tablesync worker? (Amit Kapila)
Список
Дерево обсуждения
Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Craig Ringer <craig.ringer@enterprisedb.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Dilip Kumar <dilipbalaut@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Ajin Cherian <itsajin@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Ajin Cherian <itsajin@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
RE: Single transaction in the tablesync worker? "Hou, Zhijie" <houzj.fnst@cn.fujitsu.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
RE: Single transaction in the tablesync worker? "Hou, Zhijie" <houzj.fnst@cn.fujitsu.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
RE: Single transaction in the tablesync worker? "Hou, Zhijie" <houzj.fnst@cn.fujitsu.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
RE: Single transaction in the tablesync worker? "Hou, Zhijie" <houzj.fnst@cn.fujitsu.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Ajin Cherian <itsajin@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Ajin Cherian <itsajin@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Ajin Cherian <itsajin@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Ajin Cherian <itsajin@gmail.com>
Re: Single transaction in the tablesync worker? Ajin Cherian <itsajin@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Ajin Cherian <itsajin@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Petr Jelinek <petr.jelinek@enterprisedb.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Petr Jelinek <petr.jelinek@enterprisedb.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Ajin Cherian <itsajin@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Petr Jelinek <petr.jelinek@enterprisedb.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Petr Jelinek <petr.jelinek@enterprisedb.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Petr Jelinek <petr.jelinek@enterprisedb.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Ajin Cherian <itsajin@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Ajin Cherian <itsajin@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
RE: Single transaction in the tablesync worker? "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Ajin Cherian <itsajin@gmail.com>
RE: Single transaction in the tablesync worker? "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
RE: Single transaction in the tablesync worker? "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
RE: Single transaction in the tablesync worker? "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
RE: Single transaction in the tablesync worker? "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: Single transaction in the tablesync worker? Ajin Cherian <itsajin@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Ajin Cherian <itsajin@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Peter Smith <smithpb2250@gmail.com>
Re: Single transaction in the tablesync worker? Craig Ringer <craig.ringer@enterprisedb.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Craig Ringer <craig.ringer@enterprisedb.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
Re: Single transaction in the tablesync worker? Amit Kapila <amit.kapila16@gmail.com>
On Mon, Jan 25, 2021 at 1:58 PM Amit Kapila wrote: > > On Sun, Jan 24, 2021 at 12:24 PM Peter Smith wrote: > > > > On Sat, Jan 23, 2021 at 11:26 PM Amit Kapila wrote: > > > > > > > > > Few comments: > > > ============= > > > 1. > > > - * So the state progression is always: INIT -> DATASYNC -> SYNCWAIT -> > > > - * CATCHUP -> SYNCDONE -> READY. > > > + * So the state progression is always: INIT -> DATASYNC -> > > > + * (sync worker FINISHEDCOPY) -> SYNCWAIT -> CATCHUP -> SYNCDONE -> READY. > > > > > > I don't think we need to be specific here that sync worker sets > > > FINISHEDCOPY state. > > > > > > > This was meant to indicate that *only* the sync worker knows about the > > FINISHEDCOPY state, whereas all the other states are either known > > (assigned and/or used) by *both* kinds of workers. But, I can remove > > it if you feel that distinction is not useful. > > > > Okay, but I feel you can mention that in the description you have > added for FINISHEDCOPY state. It looks a bit odd here and the message > you want to convey is also not that clear. > The comment is updated in the latest patch [v20]. ---- [v20] https://www.postgresql.org/message-id/CAHut%2BPuNwSujoL_dwa%3DTtozJ_vF%3DCnJxjgQTCmNBkazd8J1m-A%40mail.gmail.com Kind Regards, Peter Smith. Fujitsu Australia
В списке pgsql-hackers по дате отправления