0001 ================================================================================================
0002 Join Benchmark
0003 ================================================================================================
0004
0005 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0006 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0007 Join w long: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0008 ------------------------------------------------------------------------------------------------------------------------
0009 Join w long wholestage off 4441 4572 185 4.7 211.8 1.0X
0010 Join w long wholestage on 1409 1500 96 14.9 67.2 3.2X
0011
0012 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0013 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0014 Join w long duplicated: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0015 ------------------------------------------------------------------------------------------------------------------------
0016 Join w long duplicated wholestage off 5111 5116 7 4.1 243.7 1.0X
0017 Join w long duplicated wholestage on 1493 1518 22 14.0 71.2 3.4X
0018
0019 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0020 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0021 Join w 2 ints: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0022 ------------------------------------------------------------------------------------------------------------------------
0023 Join w 2 ints wholestage off 171821 171906 121 0.1 8193.0 1.0X
0024 Join w 2 ints wholestage on 166559 166975 263 0.1 7942.1 1.0X
0025
0026 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0027 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0028 Join w 2 longs: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0029 ------------------------------------------------------------------------------------------------------------------------
0030 Join w 2 longs wholestage off 7511 7555 62 2.8 358.2 1.0X
0031 Join w 2 longs wholestage on 3776 4119 232 5.6 180.1 2.0X
0032
0033 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0034 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0035 Join w 2 longs duplicated: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0036 ------------------------------------------------------------------------------------------------------------------------
0037 Join w 2 longs duplicated wholestage off 13563 13617 77 1.5 646.7 1.0X
0038 Join w 2 longs duplicated wholestage on 7947 8053 71 2.6 378.9 1.7X
0039
0040 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0041 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0042 outer join w long: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0043 ------------------------------------------------------------------------------------------------------------------------
0044 outer join w long wholestage off 3915 3923 12 5.4 186.7 1.0X
0045 outer join w long wholestage on 1421 1461 30 14.8 67.8 2.8X
0046
0047 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0048 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0049 semi join w long: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0050 ------------------------------------------------------------------------------------------------------------------------
0051 semi join w long wholestage off 2310 2332 30 9.1 110.2 1.0X
0052 semi join w long wholestage on 835 860 34 25.1 39.8 2.8X
0053
0054 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0055 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0056 sort merge join: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0057 ------------------------------------------------------------------------------------------------------------------------
0058 sort merge join wholestage off 1846 1886 56 1.1 880.5 1.0X
0059 sort merge join wholestage on 1402 1654 234 1.5 668.3 1.3X
0060
0061 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0062 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0063 sort merge join with duplicates: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0064 ------------------------------------------------------------------------------------------------------------------------
0065 sort merge join with duplicates wholestage off 2852 2879 38 0.7 1360.0 1.0X
0066 sort merge join with duplicates wholestage on 2645 2742 156 0.8 1261.0 1.1X
0067
0068 OpenJDK 64-Bit Server VM 11.0.5+10-post-Ubuntu-0ubuntu1.118.04 on Linux 4.15.0-1044-aws
0069 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
0070 shuffle hash join: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
0071 ------------------------------------------------------------------------------------------------------------------------
0072 shuffle hash join wholestage off 1506 1564 82 2.8 359.1 1.0X
0073 shuffle hash join wholestage on 1303 1330 23 3.2 310.6 1.2X
0074
0075