I wrote: > > 0010 - Thresholds on my TODO list. > > I did some basic tests on the insertion sort thresholds, and it looks > like we could safely and profitably increase the current value from 7 > to 20 or so, in line with other more recent implementations. I've > attached an addendum on top of 0012 and the full test results on an > Intel Coffee Lake machine with gcc 11.1. I found that the object test > setup in 0012 had some kind of bug that was comparing the pointer of > the object array. Rather than fix that, I decided to use Datums, but > with the two extremes in comparator: simple branching with machine > instructions vs. a SQL-callable function. The papers I've read > indicate the results for Datum sizes would not be much different for > small structs. The largest existing sort element is SortTuple, but > that's only 24 bytes and has a bulky comparator as well. > > The first thing to note is that I rejected outright any testing of a > "middle value" where the pivot is simply the middle of the array. Even > the Bently and McIlroy paper which is the reference for our > implementation says "The range that consists of the single integer 7 > could be eliminated, but has been left adjustable because on some > machines larger ranges are a few percent better". > > I tested thresholds up to 64, which is where I guessed results to get > worse (most implementations are smaller than that). Here are the best > thresholds at a quick glance: > > - elementary comparator: > > random: 16 or greater > decreasing, rotate: get noticeably better all the way up to 64 > organ: little difference, but seems to get better all the way up to 64 > 0/1: seems to get worse above 20 > > - SQL-callable comparator: > > random: between 12 and 20, but slight differences until 32 > decreasing, rotate: get noticeably better all the way up to 64 > organ: seems best at 12, but slight differences until 32 > 0/1: slight differences > > Based on these tests and this machine, it seems 20 is a good default > value. I'll repeat this test on one older Intel and one non-Intel > platform with older compilers.
The above was an Intel Comet Lake / gcc 11, and I've run the same test on a Haswell-era Xeon / gcc 8 and a Power8 machine / gcc 4.8. The results on those machines are pretty close to the above (full results attached). The noticeable exception is the Power8 on random input with a slow comparator -- those measurements there are more random than others so we can't draw conclusions from them, but the deviations are small in any case. I'm still thinking 20 or so is about right. I've put a lot out here recently, so I'll take a break now and come back in a few weeks. (no running tally here because the conclusions haven't changed since last message) -- John Naylor EDB: http://www.enterprisedb.com
NOTICE: [direct] size=8MB, order=random, threshold=7, test=0, time=0.130188 NOTICE: [direct] size=8MB, order=random, threshold=7, test=1, time=0.124503 NOTICE: [direct] size=8MB, order=random, threshold=7, test=2, time=0.124557 NOTICE: [direct] size=8MB, order=random, threshold=12, test=0, time=0.119103 NOTICE: [direct] size=8MB, order=random, threshold=12, test=1, time=0.119035 NOTICE: [direct] size=8MB, order=random, threshold=12, test=2, time=0.086948 NOTICE: [direct] size=8MB, order=random, threshold=16, test=0, time=0.082710 NOTICE: [direct] size=8MB, order=random, threshold=16, test=1, time=0.082771 NOTICE: [direct] size=8MB, order=random, threshold=16, test=2, time=0.083004 NOTICE: [direct] size=8MB, order=random, threshold=20, test=0, time=0.080768 NOTICE: [direct] size=8MB, order=random, threshold=20, test=1, time=0.080764 NOTICE: [direct] size=8MB, order=random, threshold=20, test=2, time=0.080635 NOTICE: [direct] size=8MB, order=random, threshold=24, test=0, time=0.080678 NOTICE: [direct] size=8MB, order=random, threshold=24, test=1, time=0.080555 NOTICE: [direct] size=8MB, order=random, threshold=24, test=2, time=0.080604 NOTICE: [direct] size=8MB, order=random, threshold=28, test=0, time=0.079002 NOTICE: [direct] size=8MB, order=random, threshold=28, test=1, time=0.078901 NOTICE: [direct] size=8MB, order=random, threshold=28, test=2, time=0.082200 NOTICE: [direct] size=8MB, order=random, threshold=32, test=0, time=0.079317 NOTICE: [direct] size=8MB, order=random, threshold=32, test=1, time=0.079164 NOTICE: [direct] size=8MB, order=random, threshold=32, test=2, time=0.079308 NOTICE: [direct] size=8MB, order=random, threshold=64, test=0, time=0.078604 NOTICE: [direct] size=8MB, order=random, threshold=64, test=1, time=0.078718 NOTICE: [direct] size=8MB, order=random, threshold=64, test=2, time=0.078689 NOTICE: [direct] size=8MB, order=decreasing, threshold=7, test=0, time=0.025097 NOTICE: [direct] size=8MB, order=decreasing, threshold=7, test=1, time=0.025078 NOTICE: [direct] size=8MB, order=decreasing, threshold=7, test=2, time=0.025095 NOTICE: [direct] size=8MB, order=decreasing, threshold=12, test=0, time=0.028298 NOTICE: [direct] size=8MB, order=decreasing, threshold=12, test=1, time=0.028600 NOTICE: [direct] size=8MB, order=decreasing, threshold=12, test=2, time=0.028688 NOTICE: [direct] size=8MB, order=decreasing, threshold=16, test=0, time=0.023474 NOTICE: [direct] size=8MB, order=decreasing, threshold=16, test=1, time=0.022533 NOTICE: [direct] size=8MB, order=decreasing, threshold=16, test=2, time=0.022542 NOTICE: [direct] size=8MB, order=decreasing, threshold=20, test=0, time=0.021052 NOTICE: [direct] size=8MB, order=decreasing, threshold=20, test=1, time=0.021067 NOTICE: [direct] size=8MB, order=decreasing, threshold=20, test=2, time=0.021094 NOTICE: [direct] size=8MB, order=decreasing, threshold=24, test=0, time=0.021183 NOTICE: [direct] size=8MB, order=decreasing, threshold=24, test=1, time=0.019644 NOTICE: [direct] size=8MB, order=decreasing, threshold=24, test=2, time=0.021944 NOTICE: [direct] size=8MB, order=decreasing, threshold=28, test=0, time=0.020768 NOTICE: [direct] size=8MB, order=decreasing, threshold=28, test=1, time=0.020800 NOTICE: [direct] size=8MB, order=decreasing, threshold=28, test=2, time=0.020818 NOTICE: [direct] size=8MB, order=decreasing, threshold=32, test=0, time=0.016608 NOTICE: [direct] size=8MB, order=decreasing, threshold=32, test=1, time=0.016694 NOTICE: [direct] size=8MB, order=decreasing, threshold=32, test=2, time=0.014228 NOTICE: [direct] size=8MB, order=decreasing, threshold=64, test=0, time=0.012651 NOTICE: [direct] size=8MB, order=decreasing, threshold=64, test=1, time=0.012691 NOTICE: [direct] size=8MB, order=decreasing, threshold=64, test=2, time=0.012657 NOTICE: [direct] size=8MB, order=organ, threshold=7, test=0, time=0.031979 NOTICE: [direct] size=8MB, order=organ, threshold=7, test=1, time=0.032628 NOTICE: [direct] size=8MB, order=organ, threshold=7, test=2, time=0.034789 NOTICE: [direct] size=8MB, order=organ, threshold=12, test=0, time=0.033848 NOTICE: [direct] size=8MB, order=organ, threshold=12, test=1, time=0.034084 NOTICE: [direct] size=8MB, order=organ, threshold=12, test=2, time=0.034066 NOTICE: [direct] size=8MB, order=organ, threshold=16, test=0, time=0.033714 NOTICE: [direct] size=8MB, order=organ, threshold=16, test=1, time=0.031153 NOTICE: [direct] size=8MB, order=organ, threshold=16, test=2, time=0.030619 NOTICE: [direct] size=8MB, order=organ, threshold=20, test=0, time=0.029174 NOTICE: [direct] size=8MB, order=organ, threshold=20, test=1, time=0.029080 NOTICE: [direct] size=8MB, order=organ, threshold=20, test=2, time=0.029134 NOTICE: [direct] size=8MB, order=organ, threshold=24, test=0, time=0.029543 NOTICE: [direct] size=8MB, order=organ, threshold=24, test=1, time=0.031115 NOTICE: [direct] size=8MB, order=organ, threshold=24, test=2, time=0.029267 NOTICE: [direct] size=8MB, order=organ, threshold=28, test=0, time=0.031434 NOTICE: [direct] size=8MB, order=organ, threshold=28, test=1, time=0.030909 NOTICE: [direct] size=8MB, order=organ, threshold=28, test=2, time=0.031286 NOTICE: [direct] size=8MB, order=organ, threshold=32, test=0, time=0.030325 NOTICE: [direct] size=8MB, order=organ, threshold=32, test=1, time=0.031663 NOTICE: [direct] size=8MB, order=organ, threshold=32, test=2, time=0.029483 NOTICE: [direct] size=8MB, order=organ, threshold=64, test=0, time=0.029878 NOTICE: [direct] size=8MB, order=organ, threshold=64, test=1, time=0.027732 NOTICE: [direct] size=8MB, order=organ, threshold=64, test=2, time=0.027810 NOTICE: [direct] size=8MB, order=rotate, threshold=7, test=0, time=0.039798 NOTICE: [direct] size=8MB, order=rotate, threshold=7, test=1, time=0.041404 NOTICE: [direct] size=8MB, order=rotate, threshold=7, test=2, time=0.041448 NOTICE: [direct] size=8MB, order=rotate, threshold=12, test=0, time=0.041109 NOTICE: [direct] size=8MB, order=rotate, threshold=12, test=1, time=0.039040 NOTICE: [direct] size=8MB, order=rotate, threshold=12, test=2, time=0.040159 NOTICE: [direct] size=8MB, order=rotate, threshold=16, test=0, time=0.039888 NOTICE: [direct] size=8MB, order=rotate, threshold=16, test=1, time=0.033059 NOTICE: [direct] size=8MB, order=rotate, threshold=16, test=2, time=0.033026 NOTICE: [direct] size=8MB, order=rotate, threshold=20, test=0, time=0.034844 NOTICE: [direct] size=8MB, order=rotate, threshold=20, test=1, time=0.036850 NOTICE: [direct] size=8MB, order=rotate, threshold=20, test=2, time=0.034298 NOTICE: [direct] size=8MB, order=rotate, threshold=24, test=0, time=0.035277 NOTICE: [direct] size=8MB, order=rotate, threshold=24, test=1, time=0.031883 NOTICE: [direct] size=8MB, order=rotate, threshold=24, test=2, time=0.027935 NOTICE: [direct] size=8MB, order=rotate, threshold=28, test=0, time=0.028481 NOTICE: [direct] size=8MB, order=rotate, threshold=28, test=1, time=0.030083 NOTICE: [direct] size=8MB, order=rotate, threshold=28, test=2, time=0.028839 NOTICE: [direct] size=8MB, order=rotate, threshold=32, test=0, time=0.027836 NOTICE: [direct] size=8MB, order=rotate, threshold=32, test=1, time=0.020969 NOTICE: [direct] size=8MB, order=rotate, threshold=32, test=2, time=0.020947 NOTICE: [direct] size=8MB, order=rotate, threshold=64, test=0, time=0.020864 NOTICE: [direct] size=8MB, order=rotate, threshold=64, test=1, time=0.021864 NOTICE: [direct] size=8MB, order=rotate, threshold=64, test=2, time=0.021107 NOTICE: [direct] size=8MB, order=0_1, threshold=7, test=0, time=0.005454 NOTICE: [direct] size=8MB, order=0_1, threshold=7, test=1, time=0.005434 NOTICE: [direct] size=8MB, order=0_1, threshold=7, test=2, time=0.005445 NOTICE: [direct] size=8MB, order=0_1, threshold=12, test=0, time=0.005482 NOTICE: [direct] size=8MB, order=0_1, threshold=12, test=1, time=0.005465 NOTICE: [direct] size=8MB, order=0_1, threshold=12, test=2, time=0.005498 NOTICE: [direct] size=8MB, order=0_1, threshold=16, test=0, time=0.005494 NOTICE: [direct] size=8MB, order=0_1, threshold=16, test=1, time=0.005510 NOTICE: [direct] size=8MB, order=0_1, threshold=16, test=2, time=0.005496 NOTICE: [direct] size=8MB, order=0_1, threshold=20, test=0, time=0.005484 NOTICE: [direct] size=8MB, order=0_1, threshold=20, test=1, time=0.005472 NOTICE: [direct] size=8MB, order=0_1, threshold=20, test=2, time=0.005484 NOTICE: [direct] size=8MB, order=0_1, threshold=24, test=0, time=0.005514 NOTICE: [direct] size=8MB, order=0_1, threshold=24, test=1, time=0.005519 NOTICE: [direct] size=8MB, order=0_1, threshold=24, test=2, time=0.005596 NOTICE: [direct] size=8MB, order=0_1, threshold=28, test=0, time=0.005488 NOTICE: [direct] size=8MB, order=0_1, threshold=28, test=1, time=0.005471 NOTICE: [direct] size=8MB, order=0_1, threshold=28, test=2, time=0.005479 NOTICE: [direct] size=8MB, order=0_1, threshold=32, test=0, time=0.005520 NOTICE: [direct] size=8MB, order=0_1, threshold=32, test=1, time=0.005508 NOTICE: [direct] size=8MB, order=0_1, threshold=32, test=2, time=0.005527 NOTICE: [direct] size=8MB, order=0_1, threshold=64, test=0, time=0.005453 NOTICE: [direct] size=8MB, order=0_1, threshold=64, test=1, time=0.005443 NOTICE: [direct] size=8MB, order=0_1, threshold=64, test=2, time=0.005437 NOTICE: [direct] size=8MB, order=increasing, threshold=7, test=0, time=0.000986 NOTICE: [direct] size=8MB, order=increasing, threshold=7, test=1, time=0.000976 NOTICE: [direct] size=8MB, order=increasing, threshold=7, test=2, time=0.000979 NOTICE: [direct] size=8MB, order=increasing, threshold=12, test=0, time=0.000981 NOTICE: [direct] size=8MB, order=increasing, threshold=12, test=1, time=0.000985 NOTICE: [direct] size=8MB, order=increasing, threshold=12, test=2, time=0.000986 NOTICE: [direct] size=8MB, order=increasing, threshold=16, test=0, time=0.000981 NOTICE: [direct] size=8MB, order=increasing, threshold=16, test=1, time=0.000976 NOTICE: [direct] size=8MB, order=increasing, threshold=16, test=2, time=0.000982 NOTICE: [direct] size=8MB, order=increasing, threshold=20, test=0, time=0.000980 NOTICE: [direct] size=8MB, order=increasing, threshold=20, test=1, time=0.000981 NOTICE: [direct] size=8MB, order=increasing, threshold=20, test=2, time=0.000977 NOTICE: [direct] size=8MB, order=increasing, threshold=24, test=0, time=0.000982 NOTICE: [direct] size=8MB, order=increasing, threshold=24, test=1, time=0.000980 NOTICE: [direct] size=8MB, order=increasing, threshold=24, test=2, time=0.000984 NOTICE: [direct] size=8MB, order=increasing, threshold=28, test=0, time=0.000980 NOTICE: [direct] size=8MB, order=increasing, threshold=28, test=1, time=0.000979 NOTICE: [direct] size=8MB, order=increasing, threshold=28, test=2, time=0.000986 NOTICE: [direct] size=8MB, order=increasing, threshold=32, test=0, time=0.000984 NOTICE: [direct] size=8MB, order=increasing, threshold=32, test=1, time=0.000978 NOTICE: [direct] size=8MB, order=increasing, threshold=32, test=2, time=0.000976 NOTICE: [direct] size=8MB, order=increasing, threshold=64, test=0, time=0.000981 NOTICE: [direct] size=8MB, order=increasing, threshold=64, test=1, time=0.000982 NOTICE: [direct] size=8MB, order=increasing, threshold=64, test=2, time=0.000982 NOTICE: [SQL inlined] size=8MB, order=random, threshold=7, test=0, time=0.208315 NOTICE: [SQL inlined] size=8MB, order=random, threshold=7, test=1, time=0.209714 NOTICE: [SQL inlined] size=8MB, order=random, threshold=7, test=2, time=0.210758 NOTICE: [SQL inlined] size=8MB, order=random, threshold=12, test=0, time=0.202144 NOTICE: [SQL inlined] size=8MB, order=random, threshold=12, test=1, time=0.202061 NOTICE: [SQL inlined] size=8MB, order=random, threshold=12, test=2, time=0.201736 NOTICE: [SQL inlined] size=8MB, order=random, threshold=16, test=0, time=0.198315 NOTICE: [SQL inlined] size=8MB, order=random, threshold=16, test=1, time=0.198396 NOTICE: [SQL inlined] size=8MB, order=random, threshold=16, test=2, time=0.198130 NOTICE: [SQL inlined] size=8MB, order=random, threshold=20, test=0, time=0.197979 NOTICE: [SQL inlined] size=8MB, order=random, threshold=20, test=1, time=0.197816 NOTICE: [SQL inlined] size=8MB, order=random, threshold=20, test=2, time=0.197861 NOTICE: [SQL inlined] size=8MB, order=random, threshold=24, test=0, time=0.198134 NOTICE: [SQL inlined] size=8MB, order=random, threshold=24, test=1, time=0.198119 NOTICE: [SQL inlined] size=8MB, order=random, threshold=24, test=2, time=0.198246 NOTICE: [SQL inlined] size=8MB, order=random, threshold=28, test=0, time=0.199407 NOTICE: [SQL inlined] size=8MB, order=random, threshold=28, test=1, time=0.199488 NOTICE: [SQL inlined] size=8MB, order=random, threshold=28, test=2, time=0.199439 NOTICE: [SQL inlined] size=8MB, order=random, threshold=32, test=0, time=0.201207 NOTICE: [SQL inlined] size=8MB, order=random, threshold=32, test=1, time=0.201077 NOTICE: [SQL inlined] size=8MB, order=random, threshold=32, test=2, time=0.200801 NOTICE: [SQL inlined] size=8MB, order=random, threshold=64, test=0, time=0.226759 NOTICE: [SQL inlined] size=8MB, order=random, threshold=64, test=1, time=0.226719 NOTICE: [SQL inlined] size=8MB, order=random, threshold=64, test=2, time=0.226747 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=7, test=0, time=0.155162 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=7, test=1, time=0.155236 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=7, test=2, time=0.154983 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=12, test=0, time=0.144055 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=12, test=1, time=0.142436 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=12, test=2, time=0.142224 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=16, test=0, time=0.128516 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=16, test=1, time=0.128373 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=16, test=2, time=0.128428 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=20, test=0, time=0.121263 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=20, test=1, time=0.121262 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=20, test=2, time=0.121271 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=24, test=0, time=0.113071 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=24, test=1, time=0.113082 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=24, test=2, time=0.113139 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=28, test=0, time=0.103668 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=28, test=1, time=0.103569 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=28, test=2, time=0.103516 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=32, test=0, time=0.091925 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=32, test=1, time=0.091926 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=32, test=2, time=0.091930 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=64, test=0, time=0.098095 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=64, test=1, time=0.098131 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=64, test=2, time=0.098185 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=7, test=0, time=0.146850 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=7, test=1, time=0.147078 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=7, test=2, time=0.146970 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=12, test=0, time=0.138570 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=12, test=1, time=0.138620 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=12, test=2, time=0.138630 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=16, test=0, time=0.135585 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=16, test=1, time=0.135834 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=16, test=2, time=0.135702 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=20, test=0, time=0.137001 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=20, test=1, time=0.135744 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=20, test=2, time=0.135733 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=24, test=0, time=0.136145 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=24, test=1, time=0.136117 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=24, test=2, time=0.136056 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=28, test=0, time=0.137421 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=28, test=1, time=0.137360 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=28, test=2, time=0.137347 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=32, test=0, time=0.139029 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=32, test=1, time=0.138865 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=32, test=2, time=0.138763 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=64, test=0, time=0.171138 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=64, test=1, time=0.171431 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=64, test=2, time=0.171247 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=7, test=0, time=0.255147 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=7, test=1, time=0.255173 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=7, test=2, time=0.254916 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=12, test=0, time=0.234074 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=12, test=1, time=0.234053 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=12, test=2, time=0.234080 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=16, test=0, time=0.220700 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=16, test=1, time=0.225915 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=16, test=2, time=0.220645 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=20, test=0, time=0.208890 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=20, test=1, time=0.208830 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=20, test=2, time=0.208906 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=24, test=0, time=0.195011 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=24, test=1, time=0.194661 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=24, test=2, time=0.194555 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=28, test=0, time=0.178136 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=28, test=1, time=0.178086 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=28, test=2, time=0.178177 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=32, test=0, time=0.160916 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=32, test=1, time=0.160867 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=32, test=2, time=0.177536 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=64, test=0, time=0.189746 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=64, test=1, time=0.192101 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=64, test=2, time=0.192363 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=7, test=0, time=0.015848 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=7, test=1, time=0.015293 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=7, test=2, time=0.013484 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=12, test=0, time=0.012652 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=12, test=1, time=0.012572 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=12, test=2, time=0.015349 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=16, test=0, time=0.015498 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=16, test=1, time=0.015538 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=16, test=2, time=0.015209 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=20, test=0, time=0.015378 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=20, test=1, time=0.015127 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=20, test=2, time=0.014118 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=24, test=0, time=0.015498 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=24, test=1, time=0.013113 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=24, test=2, time=0.012596 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=28, test=0, time=0.012589 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=28, test=1, time=0.014931 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=28, test=2, time=0.015270 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=32, test=0, time=0.015852 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=32, test=1, time=0.015677 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=32, test=2, time=0.015190 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=64, test=0, time=0.015729 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=64, test=1, time=0.013846 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=64, test=2, time=0.012660 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=7, test=0, time=0.004575 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=7, test=1, time=0.004647 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=7, test=2, time=0.005002 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=12, test=0, time=0.005673 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=12, test=1, time=0.005789 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=12, test=2, time=0.005438 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=16, test=0, time=0.005694 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=16, test=1, time=0.005730 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=16, test=2, time=0.005329 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=20, test=0, time=0.005701 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=20, test=1, time=0.005646 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=20, test=2, time=0.005715 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=24, test=0, time=0.005568 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=24, test=1, time=0.005624 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=24, test=2, time=0.005655 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=28, test=0, time=0.005129 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=28, test=1, time=0.005760 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=28, test=2, time=0.005698 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=32, test=0, time=0.005672 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=32, test=1, time=0.005636 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=32, test=2, time=0.005030 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=64, test=0, time=0.004773 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=64, test=1, time=0.004719 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=64, test=2, time=0.004764
NOTICE: [direct] size=8MB, order=random, threshold=7, test=0, time=0.171681 NOTICE: [direct] size=8MB, order=random, threshold=7, test=1, time=0.171542 NOTICE: [direct] size=8MB, order=random, threshold=7, test=2, time=0.171553 NOTICE: [direct] size=8MB, order=random, threshold=12, test=0, time=0.166650 NOTICE: [direct] size=8MB, order=random, threshold=12, test=1, time=0.166576 NOTICE: [direct] size=8MB, order=random, threshold=12, test=2, time=0.167606 NOTICE: [direct] size=8MB, order=random, threshold=16, test=0, time=0.163613 NOTICE: [direct] size=8MB, order=random, threshold=16, test=1, time=0.163577 NOTICE: [direct] size=8MB, order=random, threshold=16, test=2, time=0.163560 NOTICE: [direct] size=8MB, order=random, threshold=20, test=0, time=0.162284 NOTICE: [direct] size=8MB, order=random, threshold=20, test=1, time=0.162177 NOTICE: [direct] size=8MB, order=random, threshold=20, test=2, time=0.162194 NOTICE: [direct] size=8MB, order=random, threshold=24, test=0, time=0.162262 NOTICE: [direct] size=8MB, order=random, threshold=24, test=1, time=0.162254 NOTICE: [direct] size=8MB, order=random, threshold=24, test=2, time=0.162261 NOTICE: [direct] size=8MB, order=random, threshold=28, test=0, time=0.162574 NOTICE: [direct] size=8MB, order=random, threshold=28, test=1, time=0.162561 NOTICE: [direct] size=8MB, order=random, threshold=28, test=2, time=0.163105 NOTICE: [direct] size=8MB, order=random, threshold=32, test=0, time=0.160633 NOTICE: [direct] size=8MB, order=random, threshold=32, test=1, time=0.160611 NOTICE: [direct] size=8MB, order=random, threshold=32, test=2, time=0.169342 NOTICE: [direct] size=8MB, order=random, threshold=64, test=0, time=0.163429 NOTICE: [direct] size=8MB, order=random, threshold=64, test=1, time=0.163418 NOTICE: [direct] size=8MB, order=random, threshold=64, test=2, time=0.163436 NOTICE: [direct] size=8MB, order=decreasing, threshold=7, test=0, time=0.098568 NOTICE: [direct] size=8MB, order=decreasing, threshold=7, test=1, time=0.098736 NOTICE: [direct] size=8MB, order=decreasing, threshold=7, test=2, time=0.098731 NOTICE: [direct] size=8MB, order=decreasing, threshold=12, test=0, time=0.094295 NOTICE: [direct] size=8MB, order=decreasing, threshold=12, test=1, time=0.098204 NOTICE: [direct] size=8MB, order=decreasing, threshold=12, test=2, time=0.094158 NOTICE: [direct] size=8MB, order=decreasing, threshold=16, test=0, time=0.089945 NOTICE: [direct] size=8MB, order=decreasing, threshold=16, test=1, time=0.090141 NOTICE: [direct] size=8MB, order=decreasing, threshold=16, test=2, time=0.090148 NOTICE: [direct] size=8MB, order=decreasing, threshold=20, test=0, time=0.084398 NOTICE: [direct] size=8MB, order=decreasing, threshold=20, test=1, time=0.083994 NOTICE: [direct] size=8MB, order=decreasing, threshold=20, test=2, time=0.084104 NOTICE: [direct] size=8MB, order=decreasing, threshold=24, test=0, time=0.077245 NOTICE: [direct] size=8MB, order=decreasing, threshold=24, test=1, time=0.077405 NOTICE: [direct] size=8MB, order=decreasing, threshold=24, test=2, time=0.077337 NOTICE: [direct] size=8MB, order=decreasing, threshold=28, test=0, time=0.069377 NOTICE: [direct] size=8MB, order=decreasing, threshold=28, test=1, time=0.069409 NOTICE: [direct] size=8MB, order=decreasing, threshold=28, test=2, time=0.069563 NOTICE: [direct] size=8MB, order=decreasing, threshold=32, test=0, time=0.059311 NOTICE: [direct] size=8MB, order=decreasing, threshold=32, test=1, time=0.059506 NOTICE: [direct] size=8MB, order=decreasing, threshold=32, test=2, time=0.059356 NOTICE: [direct] size=8MB, order=decreasing, threshold=64, test=0, time=0.054791 NOTICE: [direct] size=8MB, order=decreasing, threshold=64, test=1, time=0.054762 NOTICE: [direct] size=8MB, order=decreasing, threshold=64, test=2, time=0.054810 NOTICE: [direct] size=8MB, order=organ, threshold=7, test=0, time=0.095815 NOTICE: [direct] size=8MB, order=organ, threshold=7, test=1, time=0.095858 NOTICE: [direct] size=8MB, order=organ, threshold=7, test=2, time=0.095847 NOTICE: [direct] size=8MB, order=organ, threshold=12, test=0, time=0.094097 NOTICE: [direct] size=8MB, order=organ, threshold=12, test=1, time=0.094105 NOTICE: [direct] size=8MB, order=organ, threshold=12, test=2, time=0.094000 NOTICE: [direct] size=8MB, order=organ, threshold=16, test=0, time=0.090621 NOTICE: [direct] size=8MB, order=organ, threshold=16, test=1, time=0.090557 NOTICE: [direct] size=8MB, order=organ, threshold=16, test=2, time=0.090570 NOTICE: [direct] size=8MB, order=organ, threshold=20, test=0, time=0.089353 NOTICE: [direct] size=8MB, order=organ, threshold=20, test=1, time=0.089734 NOTICE: [direct] size=8MB, order=organ, threshold=20, test=2, time=0.089247 NOTICE: [direct] size=8MB, order=organ, threshold=24, test=0, time=0.090642 NOTICE: [direct] size=8MB, order=organ, threshold=24, test=1, time=0.090542 NOTICE: [direct] size=8MB, order=organ, threshold=24, test=2, time=0.090546 NOTICE: [direct] size=8MB, order=organ, threshold=28, test=0, time=0.090770 NOTICE: [direct] size=8MB, order=organ, threshold=28, test=1, time=0.090699 NOTICE: [direct] size=8MB, order=organ, threshold=28, test=2, time=0.090706 NOTICE: [direct] size=8MB, order=organ, threshold=32, test=0, time=0.088122 NOTICE: [direct] size=8MB, order=organ, threshold=32, test=1, time=0.088066 NOTICE: [direct] size=8MB, order=organ, threshold=32, test=2, time=0.088021 NOTICE: [direct] size=8MB, order=organ, threshold=64, test=0, time=0.093248 NOTICE: [direct] size=8MB, order=organ, threshold=64, test=1, time=0.093177 NOTICE: [direct] size=8MB, order=organ, threshold=64, test=2, time=0.093175 NOTICE: [direct] size=8MB, order=rotate, threshold=7, test=0, time=0.130503 NOTICE: [direct] size=8MB, order=rotate, threshold=7, test=1, time=0.130910 NOTICE: [direct] size=8MB, order=rotate, threshold=7, test=2, time=0.130844 NOTICE: [direct] size=8MB, order=rotate, threshold=12, test=0, time=0.120236 NOTICE: [direct] size=8MB, order=rotate, threshold=12, test=1, time=0.120220 NOTICE: [direct] size=8MB, order=rotate, threshold=12, test=2, time=0.120352 NOTICE: [direct] size=8MB, order=rotate, threshold=16, test=0, time=0.114728 NOTICE: [direct] size=8MB, order=rotate, threshold=16, test=1, time=0.114699 NOTICE: [direct] size=8MB, order=rotate, threshold=16, test=2, time=0.114705 NOTICE: [direct] size=8MB, order=rotate, threshold=20, test=0, time=0.107819 NOTICE: [direct] size=8MB, order=rotate, threshold=20, test=1, time=0.108353 NOTICE: [direct] size=8MB, order=rotate, threshold=20, test=2, time=0.107872 NOTICE: [direct] size=8MB, order=rotate, threshold=24, test=0, time=0.101091 NOTICE: [direct] size=8MB, order=rotate, threshold=24, test=1, time=0.101045 NOTICE: [direct] size=8MB, order=rotate, threshold=24, test=2, time=0.101020 NOTICE: [direct] size=8MB, order=rotate, threshold=28, test=0, time=0.092126 NOTICE: [direct] size=8MB, order=rotate, threshold=28, test=1, time=0.092232 NOTICE: [direct] size=8MB, order=rotate, threshold=28, test=2, time=0.092124 NOTICE: [direct] size=8MB, order=rotate, threshold=32, test=0, time=0.083511 NOTICE: [direct] size=8MB, order=rotate, threshold=32, test=1, time=0.083553 NOTICE: [direct] size=8MB, order=rotate, threshold=32, test=2, time=0.083513 NOTICE: [direct] size=8MB, order=rotate, threshold=64, test=0, time=0.077736 NOTICE: [direct] size=8MB, order=rotate, threshold=64, test=1, time=0.077656 NOTICE: [direct] size=8MB, order=rotate, threshold=64, test=2, time=0.077941 NOTICE: [direct] size=8MB, order=0_1, threshold=7, test=0, time=0.009737 NOTICE: [direct] size=8MB, order=0_1, threshold=7, test=1, time=0.009788 NOTICE: [direct] size=8MB, order=0_1, threshold=7, test=2, time=0.009791 NOTICE: [direct] size=8MB, order=0_1, threshold=12, test=0, time=0.009781 NOTICE: [direct] size=8MB, order=0_1, threshold=12, test=1, time=0.009797 NOTICE: [direct] size=8MB, order=0_1, threshold=12, test=2, time=0.009780 NOTICE: [direct] size=8MB, order=0_1, threshold=16, test=0, time=0.009805 NOTICE: [direct] size=8MB, order=0_1, threshold=16, test=1, time=0.009803 NOTICE: [direct] size=8MB, order=0_1, threshold=16, test=2, time=0.009799 NOTICE: [direct] size=8MB, order=0_1, threshold=20, test=0, time=0.009811 NOTICE: [direct] size=8MB, order=0_1, threshold=20, test=1, time=0.009806 NOTICE: [direct] size=8MB, order=0_1, threshold=20, test=2, time=0.009819 NOTICE: [direct] size=8MB, order=0_1, threshold=24, test=0, time=0.009779 NOTICE: [direct] size=8MB, order=0_1, threshold=24, test=1, time=0.009782 NOTICE: [direct] size=8MB, order=0_1, threshold=24, test=2, time=0.009779 NOTICE: [direct] size=8MB, order=0_1, threshold=28, test=0, time=0.009807 NOTICE: [direct] size=8MB, order=0_1, threshold=28, test=1, time=0.009767 NOTICE: [direct] size=8MB, order=0_1, threshold=28, test=2, time=0.009797 NOTICE: [direct] size=8MB, order=0_1, threshold=32, test=0, time=0.009804 NOTICE: [direct] size=8MB, order=0_1, threshold=32, test=1, time=0.009802 NOTICE: [direct] size=8MB, order=0_1, threshold=32, test=2, time=0.009795 NOTICE: [direct] size=8MB, order=0_1, threshold=64, test=0, time=0.009813 NOTICE: [direct] size=8MB, order=0_1, threshold=64, test=1, time=0.009807 NOTICE: [direct] size=8MB, order=0_1, threshold=64, test=2, time=0.009833 NOTICE: [direct] size=8MB, order=increasing, threshold=7, test=0, time=0.001731 NOTICE: [direct] size=8MB, order=increasing, threshold=7, test=1, time=0.001826 NOTICE: [direct] size=8MB, order=increasing, threshold=7, test=2, time=0.001820 NOTICE: [direct] size=8MB, order=increasing, threshold=12, test=0, time=0.001810 NOTICE: [direct] size=8MB, order=increasing, threshold=12, test=1, time=0.001811 NOTICE: [direct] size=8MB, order=increasing, threshold=12, test=2, time=0.001832 NOTICE: [direct] size=8MB, order=increasing, threshold=16, test=0, time=0.001819 NOTICE: [direct] size=8MB, order=increasing, threshold=16, test=1, time=0.001809 NOTICE: [direct] size=8MB, order=increasing, threshold=16, test=2, time=0.001812 NOTICE: [direct] size=8MB, order=increasing, threshold=20, test=0, time=0.001812 NOTICE: [direct] size=8MB, order=increasing, threshold=20, test=1, time=0.001811 NOTICE: [direct] size=8MB, order=increasing, threshold=20, test=2, time=0.001812 NOTICE: [direct] size=8MB, order=increasing, threshold=24, test=0, time=0.001835 NOTICE: [direct] size=8MB, order=increasing, threshold=24, test=1, time=0.001811 NOTICE: [direct] size=8MB, order=increasing, threshold=24, test=2, time=0.001833 NOTICE: [direct] size=8MB, order=increasing, threshold=28, test=0, time=0.001813 NOTICE: [direct] size=8MB, order=increasing, threshold=28, test=1, time=0.001963 NOTICE: [direct] size=8MB, order=increasing, threshold=28, test=2, time=0.001812 NOTICE: [direct] size=8MB, order=increasing, threshold=32, test=0, time=0.001813 NOTICE: [direct] size=8MB, order=increasing, threshold=32, test=1, time=0.001811 NOTICE: [direct] size=8MB, order=increasing, threshold=32, test=2, time=0.001837 NOTICE: [direct] size=8MB, order=increasing, threshold=64, test=0, time=0.001811 NOTICE: [direct] size=8MB, order=increasing, threshold=64, test=1, time=0.001811 NOTICE: [direct] size=8MB, order=increasing, threshold=64, test=2, time=0.001812 NOTICE: [SQL inlined] size=8MB, order=random, threshold=7, test=0, time=0.395326 NOTICE: [SQL inlined] size=8MB, order=random, threshold=7, test=1, time=0.370237 NOTICE: [SQL inlined] size=8MB, order=random, threshold=7, test=2, time=0.369997 NOTICE: [SQL inlined] size=8MB, order=random, threshold=12, test=0, time=0.366812 NOTICE: [SQL inlined] size=8MB, order=random, threshold=12, test=1, time=0.366649 NOTICE: [SQL inlined] size=8MB, order=random, threshold=12, test=2, time=0.366801 NOTICE: [SQL inlined] size=8MB, order=random, threshold=16, test=0, time=0.365210 NOTICE: [SQL inlined] size=8MB, order=random, threshold=16, test=1, time=0.365016 NOTICE: [SQL inlined] size=8MB, order=random, threshold=16, test=2, time=0.365144 NOTICE: [SQL inlined] size=8MB, order=random, threshold=20, test=0, time=0.401241 NOTICE: [SQL inlined] size=8MB, order=random, threshold=20, test=1, time=0.401259 NOTICE: [SQL inlined] size=8MB, order=random, threshold=20, test=2, time=0.401179 NOTICE: [SQL inlined] size=8MB, order=random, threshold=24, test=0, time=0.373316 NOTICE: [SQL inlined] size=8MB, order=random, threshold=24, test=1, time=0.373020 NOTICE: [SQL inlined] size=8MB, order=random, threshold=24, test=2, time=0.373082 NOTICE: [SQL inlined] size=8MB, order=random, threshold=28, test=0, time=0.379247 NOTICE: [SQL inlined] size=8MB, order=random, threshold=28, test=1, time=0.379217 NOTICE: [SQL inlined] size=8MB, order=random, threshold=28, test=2, time=0.379495 NOTICE: [SQL inlined] size=8MB, order=random, threshold=32, test=0, time=0.385313 NOTICE: [SQL inlined] size=8MB, order=random, threshold=32, test=1, time=0.385051 NOTICE: [SQL inlined] size=8MB, order=random, threshold=32, test=2, time=0.385238 NOTICE: [SQL inlined] size=8MB, order=random, threshold=64, test=0, time=0.443364 NOTICE: [SQL inlined] size=8MB, order=random, threshold=64, test=1, time=0.443444 NOTICE: [SQL inlined] size=8MB, order=random, threshold=64, test=2, time=0.443095 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=7, test=0, time=0.296520 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=7, test=1, time=0.296260 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=7, test=2, time=0.296200 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=12, test=0, time=0.287378 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=12, test=1, time=0.287673 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=12, test=2, time=0.287395 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=16, test=0, time=0.274579 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=16, test=1, time=0.274521 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=16, test=2, time=0.274706 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=20, test=0, time=0.270940 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=20, test=1, time=0.270837 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=20, test=2, time=0.270920 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=24, test=0, time=0.242524 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=24, test=1, time=0.242749 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=24, test=2, time=0.242530 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=28, test=0, time=0.222845 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=28, test=1, time=0.222004 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=28, test=2, time=0.222050 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=32, test=0, time=0.196404 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=32, test=1, time=0.196410 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=32, test=2, time=0.196755 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=64, test=0, time=0.184679 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=64, test=1, time=0.184813 NOTICE: [SQL inlined] size=8MB, order=decreasing, threshold=64, test=2, time=0.184699 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=7, test=0, time=0.313411 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=7, test=1, time=0.313823 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=7, test=2, time=0.313726 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=12, test=0, time=0.302651 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=12, test=1, time=0.302799 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=12, test=2, time=0.302742 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=16, test=0, time=0.308603 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=16, test=1, time=0.309211 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=16, test=2, time=0.308911 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=20, test=0, time=0.311303 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=20, test=1, time=0.311311 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=20, test=2, time=0.311673 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=24, test=0, time=0.315066 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=24, test=1, time=0.314541 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=24, test=2, time=0.315119 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=28, test=0, time=0.312660 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=28, test=1, time=0.312468 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=28, test=2, time=0.312560 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=32, test=0, time=0.325323 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=32, test=1, time=0.325709 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=32, test=2, time=0.325741 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=64, test=0, time=0.379399 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=64, test=1, time=0.379343 NOTICE: [SQL inlined] size=8MB, order=organ, threshold=64, test=2, time=0.380079 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=7, test=0, time=0.611102 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=7, test=1, time=0.611574 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=7, test=2, time=0.610787 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=12, test=0, time=0.555359 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=12, test=1, time=0.555576 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=12, test=2, time=0.554815 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=16, test=0, time=0.570888 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=16, test=1, time=0.570357 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=16, test=2, time=0.570449 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=20, test=0, time=0.551491 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=20, test=1, time=0.551279 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=20, test=2, time=0.552095 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=24, test=0, time=0.508074 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=24, test=1, time=0.508384 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=24, test=2, time=0.508151 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=28, test=0, time=0.435767 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=28, test=1, time=0.435918 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=28, test=2, time=0.436199 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=32, test=0, time=0.423809 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=32, test=1, time=0.423085 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=32, test=2, time=0.422633 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=64, test=0, time=0.398309 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=64, test=1, time=0.398443 NOTICE: [SQL inlined] size=8MB, order=rotate, threshold=64, test=2, time=0.397198 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=7, test=0, time=0.023994 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=7, test=1, time=0.024015 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=7, test=2, time=0.023991 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=12, test=0, time=0.022991 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=12, test=1, time=0.023048 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=12, test=2, time=0.023003 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=16, test=0, time=0.024020 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=16, test=1, time=0.024036 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=16, test=2, time=0.023998 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=20, test=0, time=0.024025 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=20, test=1, time=0.024026 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=20, test=2, time=0.024040 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=24, test=0, time=0.023956 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=24, test=1, time=0.023950 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=24, test=2, time=0.023983 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=28, test=0, time=0.022963 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=28, test=1, time=0.022980 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=28, test=2, time=0.022969 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=32, test=0, time=0.024064 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=32, test=1, time=0.023996 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=32, test=2, time=0.024060 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=64, test=0, time=0.024098 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=64, test=1, time=0.023841 NOTICE: [SQL inlined] size=8MB, order=0_1, threshold=64, test=2, time=0.023815 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=7, test=0, time=0.014581 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=7, test=1, time=0.014624 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=7, test=2, time=0.014548 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=12, test=0, time=0.012959 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=12, test=1, time=0.012967 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=12, test=2, time=0.012979 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=16, test=0, time=0.014590 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=16, test=1, time=0.014561 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=16, test=2, time=0.014608 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=20, test=0, time=0.014594 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=20, test=1, time=0.014540 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=20, test=2, time=0.014527 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=24, test=0, time=0.014616 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=24, test=1, time=0.014558 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=24, test=2, time=0.014586 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=28, test=0, time=0.012759 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=28, test=1, time=0.012775 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=28, test=2, time=0.012866 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=32, test=0, time=0.014545 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=32, test=1, time=0.014608 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=32, test=2, time=0.014475 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=64, test=0, time=0.014519 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=64, test=1, time=0.014643 NOTICE: [SQL inlined] size=8MB, order=increasing, threshold=64, test=2, time=0.014531
