Re: Fix BUG #17335: Duplicate result rows in Gather node - Mailing list pgsql-hackers

From Yura Sokolov
Subject Re: Fix BUG #17335: Duplicate result rows in Gather node
Date
Msg-id e13e399626445f885ec25721c8757ec88805acc1.camel@postgrespro.ru
Whole thread Raw
In response to Re: Fix BUG #17335: Duplicate result rows in Gather node  (David Rowley <dgrowleyml@gmail.com>)
List 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 by date:

Previous
From: Alexander Pyhalov
Date:
Subject: Re: Partial aggregates pushdown
Next
From: "osumi.takamichi@fujitsu.com"
Date:
Subject: RE: Skipping logical replication transactions on subscriber side