RE: Parallel Apply

Поиск
Список
Период
Сортировка
Искать
От
Hayato Kuroda (Fujitsu)
Тема
RE: Parallel Apply
Дата
Msg-id
OSCPR01MB14966B464C274665B21FF4320F5B0A@OSCPR01MB14966.jpnprd01.prod.outlook.com
Ответ на
RE: Parallel Apply (Hayato Kuroda (Fujitsu))
Список
Дерево обсуждения
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 Hackers,

Here is a rebased version.
Since the parallel worker's bug has been fixed, the patch is not attached anymore.

0006 contains changes to handle the case that user-defined triggers are not
immutable. Some triggers may change their behaviors based on the number of tuples
and other internal states. To keep the result consistent with the non-parallel
case, parallel workers wait to apply changes till the previous transaction is
committed if the target relation has such triggers.
Note that we assume CHECK constraints are immutable, so they are not checked.
I think it is a reasonable assumption because it has already been described in
the doc [1].
(This does not contain tests yet)

0007 contains changes for track dependencies by local indexes. It was mostly the
same as v5-0008. Since I cannot find a reasonable way to compute a hash for
expression indexes, these indexes are no longer used for tracking. Instead, the
parallel worker waits to apply changes till the previous transaction is
committed if the target relation has such indexes.


[1]: https://www.postgresql.org/docs/current/ddl-constraints.html

Best regards,
Hayato Kuroda
FUJITSU LIMITED

В списке pgsql-hackers по дате отправления
От: Chao Li
Дата:
От: Chao Li
Дата:
FAQ