On Wed, 23 Nov 2022 at 10:58, David Rowley <dgrowle...@gmail.com> wrote: > My current thoughts are that it might be best to go with 0005 to start > with. I know Melanie is working on making some changes in this area, > so perhaps it's best to leave 0002 until that work is complete.
I tried running TPC-H @ scale 5 with master (@d09dbeb9) vs master + 0001 + 0005 patch. The results look quite promising. Query 15 seems to run 15% faster and overall it's 4.23% faster. Full results are attached. David
query master Master + 0001 + 0005 compare 1 25999.5 25793.6 100.8% 2 1171.0 1152.0 101.6% 3 6180.5 5456.5 113.3% 4 1167.1 1107.0 105.4% 5 4968.3 4604.8 107.9% 6 3696.6 3306.4 111.8% 7 5501.4 4905.6 112.1% 8 1394.8 1345.2 103.7% 9 10861.2 11159.8 97.3% 10 4354.3 4356.4 100.0% 11 382.5 386.3 99.0% 12 3888.6 3838.0 101.3% 13 6905.0 6622.5 104.3% 14 3886.1 3429.8 113.3% 15 8009.7 6927.8 115.6% 16 2406.2 2363.9 101.8% 17 14.6 14.9 98.1% 18 11735.6 11453.9 102.5% 19 44.9 44.7 100.4% 20 262.8 246.6 106.6% 21 3014.1 3027.6 99.6% 22 176.4 179.3 98.4%
