dongjoon-hyun commented on code in PR #39301: URL: https://github.com/apache/spark/pull/39301#discussion_r1059235934
########## sql/core/benchmarks/JoinBenchmark-jdk17-results.txt: ########## @@ -2,81 +2,81 @@ Join Benchmark ================================================================================================ -OpenJDK 64-Bit Server VM 17.0.2+8-LTS on Linux 5.13.0-1021-azure -Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz +OpenJDK 64-Bit Server VM 17.0.5+8 on Linux 5.15.0-1023-azure +Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz Join w long: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -Join w long wholestage off 4825 4831 8 4.3 230.1 1.0X -Join w long wholestage on 1688 1740 46 12.4 80.5 2.9X +Join w long wholestage off 3658 3819 227 5.7 174.4 1.0X +Join w long wholestage on 1622 1662 38 12.9 77.4 2.3X -OpenJDK 64-Bit Server VM 17.0.2+8-LTS on Linux 5.13.0-1021-azure -Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz +OpenJDK 64-Bit Server VM 17.0.5+8 on Linux 5.15.0-1023-azure +Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz Join w long duplicated: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -Join w long duplicated wholestage off 4147 4159 18 5.1 197.7 1.0X -Join w long duplicated wholestage on 1749 1757 7 12.0 83.4 2.4X +Join w long duplicated wholestage off 3727 3731 6 5.6 177.7 1.0X +Join w long duplicated wholestage on 1656 1722 67 12.7 79.0 2.3X -OpenJDK 64-Bit Server VM 17.0.2+8-LTS on Linux 5.13.0-1021-azure -Intel(R) Xeon(R) Platinum 8272CL CPU @ 2.60GHz +OpenJDK 64-Bit Server VM 17.0.5+8 on Linux 5.15.0-1023-azure +Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz Join w 2 ints: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -Join w 2 ints wholestage off 358176 358191 22 0.1 17079.1 1.0X -Join w 2 ints wholestage on 207044 207239 239 0.1 9872.6 1.7X +Join w 2 ints wholestage off 169271 170528 1778 0.1 8071.5 1.0X +Join w 2 ints wholestage on 162252 164248 NaN 0.1 7736.8 1.0X Review Comment: ditto. ########## sql/core/benchmarks/JoinBenchmark-results.txt: ########## @@ -2,81 +2,81 @@ Join Benchmark ================================================================================================ -OpenJDK 64-Bit Server VM 1.8.0_322-b06 on Linux 5.13.0-1021-azure -Intel(R) Xeon(R) CPU E5-2673 v3 @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_352-b08 on Linux 5.15.0-1023-azure +Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz Join w long: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -Join w long wholestage off 4848 5024 248 4.3 231.2 1.0X -Join w long wholestage on 1835 1861 31 11.4 87.5 2.6X +Join w long wholestage off 3444 3647 286 6.1 164.2 1.0X +Join w long wholestage on 1579 1666 52 13.3 75.3 2.2X -OpenJDK 64-Bit Server VM 1.8.0_322-b06 on Linux 5.13.0-1021-azure -Intel(R) Xeon(R) CPU E5-2673 v3 @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_352-b08 on Linux 5.15.0-1023-azure +Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz Join w long duplicated: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -Join w long duplicated wholestage off 4652 4748 135 4.5 221.8 1.0X -Join w long duplicated wholestage on 2101 2123 19 10.0 100.2 2.2X +Join w long duplicated wholestage off 3553 3636 118 5.9 169.4 1.0X +Join w long duplicated wholestage on 1873 1902 18 11.2 89.3 1.9X -OpenJDK 64-Bit Server VM 1.8.0_322-b06 on Linux 5.13.0-1021-azure -Intel(R) Xeon(R) CPU E5-2673 v3 @ 2.40GHz +OpenJDK 64-Bit Server VM 1.8.0_352-b08 on Linux 5.15.0-1023-azure +Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz Join w 2 ints: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative ------------------------------------------------------------------------------------------------------------------------ -Join w 2 ints wholestage off 426979 427823 1194 0.0 20359.9 1.0X -Join w 2 ints wholestage on 208958 209733 509 0.1 9963.9 2.0X +Join w 2 ints wholestage off 183695 184609 1292 0.1 8759.3 1.0X +Join w 2 ints wholestage on 180862 181268 311 0.1 8624.2 1.0X Review Comment: ditto. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
