Re: [HACKERS] logical decoding of two-phase transactions

Поиск
Список
Период
Сортировка
Искать
От
Amit Kapila
Тема
Re: [HACKERS] logical decoding of two-phase transactions
Дата
Msg-id
CAA4eK1JUdhaxC6MB7p0yVigcC_YUG1Bat8BS3CaK6warcBve9g@mail.gmail.com
Ответ на
Список
Дерево обсуждения
Re: [HACKERS] logical decoding of two-phase transactions Nikhil Sontakke <nikhils@2ndquadrant.com>
Re: [HACKERS] logical decoding of two-phase transactions Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] logical decoding of two-phase transactions Andres Freund <andres@anarazel.de>
Re: [HACKERS] logical decoding of two-phase transactions Nikhil Sontakke <nikhils@2ndquadrant.com>
Re: [HACKERS] logical decoding of two-phase transactions Arseny Sher <a.sher@postgrespro.ru>
Re: [HACKERS] logical decoding of two-phase transactions Andres Freund <andres@anarazel.de>
Re: [HACKERS] logical decoding of two-phase transactions Arseny Sher <a.sher@postgrespro.ru>
Re: [HACKERS] logical decoding of two-phase transactions Nikhil Sontakke <nikhils@2ndquadrant.com>
Re: [HACKERS] logical decoding of two-phase transactions Arseny Sher <a.sher@postgrespro.ru>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith <smithpb2250@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith <smithpb2250@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith <smithpb2250@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith <smithpb2250@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith <smithpb2250@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith <smithpb2250@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith <smithpb2250@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith <smithpb2250@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith <smithpb2250@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith <smithpb2250@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith <smithpb2250@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith <smithpb2250@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith <smithpb2250@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith <smithpb2250@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith <smithpb2250@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith <smithpb2250@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith <smithpb2250@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith <smithpb2250@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
RE: [HACKERS] logical decoding of two-phase transactions "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: [HACKERS] logical decoding of two-phase transactions Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith <smithpb2250@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith <smithpb2250@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith <smithpb2250@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith <smithpb2250@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith <smithpb2250@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith <smithpb2250@gmail.com>
RE: [HACKERS] logical decoding of two-phase transactions "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith <smithpb2250@gmail.com>
RE: [HACKERS] logical decoding of two-phase transactions "osumi.takamichi@fujitsu.com" <osumi.takamichi@fujitsu.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith <smithpb2250@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith <smithpb2250@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith <smithpb2250@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith <smithpb2250@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith <smithpb2250@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith <smithpb2250@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith <smithpb2250@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith <smithpb2250@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith <smithpb2250@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian <itsajin@gmail.com>
On Tue, Dec 1, 2020 at 7:55 AM Ajin Cherian  wrote:
>
> On Tue, Dec 1, 2020 at 12:46 AM Amit Kapila  wrote:
>
>
>
> > Sure, but you can see in your example above it got skipped due to
> > start_decoding_at not due to DecodingContextReady. So, the problem as
> > mentioned by me previously was how we distinguish those cases because
> > it can skip due to start_decoding_at during restart as well when we
> > would have already sent the prepare to the subscriber.
>
> The distinguishing factor is that at restart, the Prepare does satisfy
> DecodingContextReady (because the snapshot is consistent then).
> In both cases, the prepare is prior to start_decoding_at, but when the
> prepare is before a consistent point,
> it does not satisfy DecodingContextReady.
>

I think it won't be true when we reuse some already serialized
snapshot from some other slot. It is possible that we wouldn't have
encountered such a serialized snapshot while creating a slot but later
during replication, we might use it because by that time some other
slot has serialized the one at that point.

-- 
With Regards,
Amit Kapila.


В списке pgsql-hackers по дате отправления
От: Zhihong Yu
Дата:
От: Tom Lane
Дата:
FAQ