RE: Parallel Apply

Поиск
Список
Период
Сортировка
Искать
От
Hayato Kuroda (Fujitsu)
Тема
RE: Parallel Apply
Дата
Msg-id
OSCPR01MB149662F6753E26278F340438CF5D8A@OSCPR01MB14966.jpnprd01.prod.outlook.com
Ответ на
Re: Parallel Apply (Dilip Kumar)
Список
Дерево обсуждения
Parallel Apply Amit Kapila <amit.kapila16@gmail.com>
Re: Parallel Apply Andrei Lepikhov <lepihov@gmail.com>
Re: Parallel Apply Amit Kapila <amit.kapila16@gmail.com>
Re: Parallel Apply Bruce Momjian <bruce@momjian.us>
Re: Parallel Apply Amit Kapila <amit.kapila16@gmail.com>
Re: Parallel Apply Bruce Momjian <bruce@momjian.us>
Re: Parallel Apply Amit Kapila <amit.kapila16@gmail.com>
Re: Parallel Apply Mihail Nikalayeu <mihailnikalayeu@gmail.com>
Re: Parallel Apply Amit Kapila <amit.kapila16@gmail.com>
RE: Parallel Apply "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: Parallel Apply Amit Kapila <amit.kapila16@gmail.com>
RE: Parallel Apply "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: Parallel Apply Tomas Vondra <tomas@vondra.me>
Re: Parallel Apply Amit Kapila <amit.kapila16@gmail.com>
Re: Parallel Apply wenhui qiu <qiuwenhuifx@gmail.com>
Re: Parallel Apply Tomas Vondra <tomas@vondra.me>
Re: Parallel Apply wenhui qiu <qiuwenhuifx@gmail.com>
RE: Parallel Apply "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>
RE: Parallel Apply "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: Parallel Apply Andrei Lepikhov <lepihov@gmail.com>
RE: Parallel Apply "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: Parallel Apply Andrei Lepikhov <lepihov@gmail.com>
Re: Parallel Apply Amit Kapila <amit.kapila16@gmail.com>
RE: Parallel Apply "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
RE: Parallel Apply "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: Parallel Apply Dilip Kumar <dilipbalaut@gmail.com>
RE: Parallel Apply "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
RE: Parallel Apply "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
RE: Parallel Apply "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
RE: Parallel Apply "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
RE: Parallel Apply "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
RE: Parallel Apply "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
RE: Parallel Apply "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
RE: Parallel Apply "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: Parallel Apply Amit Kapila <amit.kapila16@gmail.com>
Re: Parallel Apply Amit Kapila <amit.kapila16@gmail.com>
RE: Parallel Apply "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
RE: Parallel Apply "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>
Re: Parallel Apply shveta malik <shveta.malik@gmail.com>
Re: Parallel Apply Amit Kapila <amit.kapila16@gmail.com>
RE: Parallel Apply "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>
Re: Parallel Apply shveta malik <shveta.malik@gmail.com>
Re: Parallel Apply Peter Smith <smithpb2250@gmail.com>
Re: Parallel Apply Peter Smith <smithpb2250@gmail.com>
Re: Parallel Apply shveta malik <shveta.malik@gmail.com>
RE: Parallel Apply "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>
Re: Parallel Apply shveta malik <shveta.malik@gmail.com>
Re: Parallel Apply Amit Kapila <amit.kapila16@gmail.com>
RE: Parallel Apply "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: Parallel Apply shveta malik <shveta.malik@gmail.com>
RE: Parallel Apply "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>
Re: Parallel Apply shveta malik <shveta.malik@gmail.com>
RE: Parallel Apply "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
RE: Parallel Apply "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Re: Parallel Apply Peter Smith <smithpb2250@gmail.com>
RE: Parallel Apply "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>
Re: Parallel Apply shveta malik <shveta.malik@gmail.com>
Re: Parallel Apply shveta malik <shveta.malik@gmail.com>
RE: Parallel Apply "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>
Re: Parallel Apply shveta malik <shveta.malik@gmail.com>
RE: Parallel Apply "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>
Re: Parallel Apply shveta malik <shveta.malik@gmail.com>
RE: Parallel Apply "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>
RE: Parallel Apply "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>
Re: Parallel Apply Álvaro Herrera <alvherre@kurilemu.de>
Re: Parallel Apply Amit Kapila <amit.kapila16@gmail.com>
Re: Parallel Apply Dilip Kumar <dilipbalaut@gmail.com>
RE: Parallel Apply "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
RE: Parallel Apply "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>
Re: Parallel Apply shveta malik <shveta.malik@gmail.com>
RE: Parallel Apply "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
RE: Parallel Apply "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
RE: Parallel Apply "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
RE: Parallel Apply "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>
Re: Parallel Apply Abhi Mehta <abhi15.mehta@gmail.com>
Re: Parallel Apply Amit Kapila <amit.kapila16@gmail.com>
Re: Parallel Apply Dilip Kumar <dilipbalaut@gmail.com>
Re: Parallel Apply Amit Kapila <amit.kapila16@gmail.com>
Re: Parallel Apply Kirill Reshke <reshkekirill@gmail.com>
Re: Parallel Apply Amit Kapila <amit.kapila16@gmail.com>
Re: Parallel Apply Kirill Reshke <reshkekirill@gmail.com>
Re: Parallel Apply Amit Kapila <amit.kapila16@gmail.com>
Re: Parallel Apply Константин Книжник <knizhnik@garret.ru>
Re: Parallel Apply Amit Kapila <amit.kapila16@gmail.com>
Re: Parallel Apply Konstantin Knizhnik <knizhnik@garret.ru>
RE: Parallel Apply "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>
Re: Parallel Apply Konstantin Knizhnik <knizhnik@garret.ru>
Re: Parallel Apply Konstantin Knizhnik <knizhnik@garret.ru>
RE: Parallel Apply "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>
Re: Parallel Apply Nisha Moond <nisha.moond412@gmail.com>
Re: Parallel Apply Konstantin Knizhnik <knizhnik@garret.ru>
Re: Parallel Apply Amit Kapila <amit.kapila16@gmail.com>
Re: Parallel Apply Nisha Moond <nisha.moond412@gmail.com>
Re: Parallel Apply Dilip Kumar <dilipbalaut@gmail.com>
Re: Parallel Apply Amit Kapila <amit.kapila16@gmail.com>
Re: Parallel Apply Dilip Kumar <dilipbalaut@gmail.com>
Re: Parallel Apply Amit Kapila <amit.kapila16@gmail.com>
Re: Parallel Apply Dilip Kumar <dilipbalaut@gmail.com>
Re: Parallel Apply Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Re: Parallel Apply Amit Kapila <amit.kapila16@gmail.com>
RE: Parallel Apply "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
RE: Parallel Apply "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
RE: Parallel Apply "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Dear Dilip,

> I was just going through the commit messages of all the patches, I
> could not understand the last line of below paragraph in v3-0004, what
> do you mean by the last line which says "after which the leader
> updates the
> hash entry with the current xid"?
> 
> "The leader maintains a local hash table, using the remote change's replica
> identity column values and relid as keys, with remote transaction IDs as values.
> Before sending changes to the parallel apply worker, the leader computes a hash
> using RI key values and the relid of the current change to search the hash
> table. If an existing entry is found, the leader tells the parallel worker
> to wait for the remote xid in the hash entry, after which the leader updates the
> hash entry with the current xid."

This meant if two transactions had changes for the same RI, lastly committed
transaction's XID could be stored here. In other words, each local hash entry always
has the latest XID which modifies a key (RI).

Assuming that there are three transactions T1->T2->T3 and they modify the same
tuple. When subscriber applies T3, it should wait till T2 is committed, not T1.
XID of the entry should be updated for implementing it.

I tried to rephrase that line a bit, how do you feel? All patches are attached
to keep CI happy.

Best regards,
Hayato Kuroda
FUJITSU LIMITED

В списке pgsql-hackers по дате отправления
От: Antonin Houska
Дата:
От: Peter Eisentraut
Дата:
Сообщение: Re: more C99 cleanup
FAQ