Re: [DESIGN] ParallelAppend - Mailing list pgsql-hackers

From Robert Haas
Subject Re: [DESIGN] ParallelAppend
Date
Msg-id CA+TgmoZH7hUT1hfAVYBoegZ=tT-+4RPvZeOKNYjWZOxYFzghsg@mail.gmail.com
Whole thread Raw
In response to Re: [DESIGN] ParallelAppend  (Thom Brown <thom@linux.com>)
List pgsql-hackers
On Tue, Nov 17, 2015 at 4:59 PM, Thom Brown <thom@linux.com> wrote:
> On 17 November 2015 at 20:08, Robert Haas <robertmhaas@gmail.com> wrote:
>> On Tue, Nov 17, 2015 at 4:26 AM, Thom Brown <thom@linux.com> wrote:
>>
>>> However, the first parallel seq scan shows it getting 170314 rows.
>>> Another run shows it getting 194165 rows.  The final result is
>>> correct, but as you can see from the rows on the Append node (59094295
>>> rows), it doesn't match the number of rows on the Gather node
>>> (30000000).
>>
>> Is this the same issue reported in
>> http://www.postgresql.org/message-id/CAFj8pRBF-i=qDg9b5nZrXYfChzBEZWmthxYPhidQvwoMOjHtzg@mail.gmail.com
>> and not yet fixed?  I am inclined to think it probably is.
>
> Yes, that seems to be the same issue.

I've committed a fix for that issue now, so you shouldn't see it any
more if you retest this patch.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Parallel Seq Scan
Next
From: Jeff Janes
Date:
Subject: Re: Using quicksort for every external sort run