From: | Luc Vlaming <luc(at)swarm64(dot)com> |
---|---|
To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: allow partial union-all and improve parallel subquery costing |
Date: | 2020-10-14 07:38:08 |
Message-ID: | FRXPR01MB090256263A5F23CF779CDDF4B7050@FRXPR01MB0902.DEUPRD01.PROD.OUTLOOK.DE |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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(at)swarm64(dot)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
Attachment | Content-Type | Size |
---|---|---|
v2-0001-Allow-partial-UNION-ALL-improve-parallel-subquery.patch | text/x-patch | 6.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2020-10-14 07:40:12 | Re: scram-sha-256 broken with FIPS and OpenSSL 1.0.2 |
Previous Message | Michael Paquier | 2020-10-14 07:22:56 | Re: Remove some unnecessary if-condition |