Re: Fix BUG #17335: Duplicate result rows in Gather node
От | Yura Sokolov |
---|---|
Тема | Re: Fix BUG #17335: Duplicate result rows in Gather node |
Дата | |
Msg-id | e13e399626445f885ec25721c8757ec88805acc1.camel@postgrespro.ru обсуждение исходный текст |
Ответ на | Re: Fix BUG #17335: Duplicate result rows in Gather node (David Rowley <dgrowleyml@gmail.com>) |
Список | pgsql-hackers |
В Сб, 01/01/2022 в 15:19 +1300, David Rowley пишет: > On Fri, 31 Dec 2021 at 00:14, Yura Sokolov <y.sokolov@postgrespro.ru> wrote: > > Problem: > > - Append path is created with explicitely parallel_aware = true > > - It has two child, one is trivial, other is parallel_aware = false . > > Trivial child is dropped. > > - Gather/GatherMerge path takes Append path as a child and thinks > > its child is parallel_aware = true. > > - But Append path is removed at the last since it has only one child. > > - Now Gather/GatherMerge thinks its child is parallel_aware, but it > > is not. > > Gather/GatherMerge runs its child twice: in a worker and in a leader, > > and gathers same rows twice. > > Thanks for the report. I can confirm that I can recreate the problem > with your script. > > I will look into this further later next week. > Good day, David. Excuse me for disturbing. Any update on this? Any chance to be fixed in next minor release? Could this simple fix be merged before further improvements? Yura.
В списке pgsql-hackers по дате отправления: