Re: allow partial union-all and improve parallel subquery costing

2021-12-02 Thread Daniel Gustafsson
With the thread stalled and requests for a test (documentation really?) not responded to I'm marking this patch Returned with Feedback. -- Daniel Gustafsson https://vmware.com/

Re: allow partial union-all and improve parallel subquery costing

2021-07-23 Thread Ronan Dunklau
Le lundi 12 avril 2021, 14:01:36 CEST Luc Vlaming a écrit : > Here's an improved and rebased patch. Hope the description helps some > people. I will resubmit it to the next commitfest. > Hello Luc, I've taken a look at this patch, and while I don't fully understand its implications here are a c

Re: allow partial union-all and improve parallel subquery costing

2021-04-12 Thread Luc Vlaming
Hi David, On 15-03-2021 14:09, David Steele wrote: Hi Luc, On 12/30/20 8:54 AM, Luc Vlaming wrote: Created a commitfest entry assuming this is the right thing to do so that someone can potentially pick it up during the commitfest. Providing an updated patch based on latest master. Looks

Re: allow partial union-all and improve parallel subquery costing

2021-04-08 Thread David Steele
On 3/15/21 9:09 AM, David Steele wrote: On 12/30/20 8:54 AM, Luc Vlaming wrote: Created a commitfest entry assuming this is the right thing to do so that someone can potentially pick it up during the commitfest. Providing an updated patch based on latest master. Looks like you need anothe

Re: allow partial union-all and improve parallel subquery costing

2021-03-15 Thread David Steele
Hi Luc, On 12/30/20 8:54 AM, Luc Vlaming wrote: Created a commitfest entry assuming this is the right thing to do so that someone can potentially pick it up during the commitfest. Providing an updated patch based on latest master. Looks like you need another rebase: http://cfbot.cputube.o

Re: allow partial union-all and improve parallel subquery costing

2020-12-30 Thread Luc Vlaming
: 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

Re: allow partial union-all and improve parallel subquery costing

2020-10-22 Thread Luc Vlaming
-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

Re: allow partial union-all and improve parallel subquery costing

2020-10-14 Thread Luc Vlaming
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

allow partial union-all and improve parallel subquery costing

2020-10-13 Thread Luc Vlaming
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 sh