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 по дате отправления:

Предыдущее
От: Alexander Pyhalov
Дата:
Сообщение: Re: Partial aggregates pushdown
Следующее
От: "osumi.takamichi@fujitsu.com"
Дата:
Сообщение: RE: Skipping logical replication transactions on subscriber side