Re: allow partial union-all and improve parallel subquery costing - Mailing list pgsql-hackers

From Luc Vlaming
Subject Re: allow partial union-all and improve parallel subquery costing
Date
Msg-id 36bd10c1-bae9-0520-44bb-e629d65f7321@swarm64.com
Whole thread Raw
In response to Re: allow partial union-all and improve parallel subquery costing  (Luc Vlaming <luc@swarm64.com>)
List pgsql-hackers
On 23-10-2020 07:51, Luc Vlaming wrote:
> On 14.10.20 09:38, Luc Vlaming wrote:
>> Hi,
>>
>> It seems I ran the wrong make checks to verify everything is correct 
>> (make check instead
>> of make installcheck-world) and this uncovered another regress test 
>> change. I also noticed
>> the statistics are sometimes giving different row count results so I 
>> increased the row
>> statistics target to make sure the regress output is stable. Updated 
>> patch attached which
>> now successfully runs installcheck-world for v13 and master.
>>
>> Kind regards,
>> Luc
>>
>> ________________________________________
>> From: Luc Vlaming <luc@swarm64.com>
>> Sent: Tuesday, October 13, 2020 10:57 AM
>> To: pgsql-hackers
>> Subject: allow partial union-all and improve parallel subquery costing
>>
>> Hi,
>>
>> While developing some improvements for TPC-DS queries I found out that 
>> with
>> UNION ALL partial paths are not emitted. Whilst fixing that I also 
>> came across
>> the subquery costing which does not seem to consider parallelism when 
>> doing
>> the costing.
>>
>> I added a simplified testcase in pg-regress to show this goes wrong, and
>> attached also a before and after explain output of tpc-ds SF100 query 5
>> based on version 12.4.
>>
>> I hope I followed all etiquette and these kind of improvements are 
>> welcome.
>>
>> Kind regards,
>> Luc
>> Swarm64
>>
> 
> Hi,
> 
> Created a commitfest entry assuming this is the right thing to do so 
> that someone can potentially pick it up during the commitfest.
> 
> Kind regards,
> Luc
> Swarm64

Hi,

Providing an updated patch based on latest master.

Cheers,
Luc

Attachment

pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Disable WAL logging to speed up data loading
Next
From: "赵锐"
Date:
Subject: Re: adding partitioned tables to publications