| ================================================================================================ |
| Join Benchmark |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| Join w long: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| Join w long wholestage off 2129 2153 35 9.9 101.5 1.0X |
| Join w long wholestage on 1042 1061 18 20.1 49.7 2.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| 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 1926 1928 3 10.9 91.9 1.0X |
| Join w long duplicated wholestage on 903 935 24 23.2 43.1 2.1X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| 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 113049 113083 48 0.2 5390.6 1.0X |
| Join w 2 ints wholestage on 111846 111980 140 0.2 5333.2 1.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| Join w 2 longs: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| Join w 2 longs wholestage off 3397 3423 37 6.2 162.0 1.0X |
| Join w 2 longs wholestage on 2178 2202 40 9.6 103.9 1.6X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| Join w 2 longs duplicated: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| Join w 2 longs duplicated wholestage off 8345 8367 30 2.5 397.9 1.0X |
| Join w 2 longs duplicated wholestage on 5515 5539 25 3.8 263.0 1.5X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| outer join w long: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| outer join w long wholestage off 1709 1711 4 12.3 81.5 1.0X |
| outer join w long wholestage on 1015 1018 3 20.7 48.4 1.7X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| semi join w long: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| semi join w long wholestage off 1070 1072 3 19.6 51.0 1.0X |
| semi join w long wholestage on 529 542 8 39.6 25.2 2.0X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| sort merge join: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| sort merge join wholestage off 528 530 3 4.0 251.7 1.0X |
| sort merge join wholestage on 470 482 11 4.5 224.3 1.1X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| sort merge join with duplicates: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------------ |
| sort merge join with duplicates wholestage off 1042 1046 6 2.0 497.0 1.0X |
| sort merge join with duplicates wholestage on 933 939 4 2.2 444.9 1.1X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| shuffle hash join: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| shuffle hash join wholestage off 497 499 3 8.4 118.4 1.0X |
| shuffle hash join wholestage on 368 379 7 11.4 87.7 1.3X |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| broadcast nested loop join: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------- |
| broadcast nested loop join wholestage off 26769 26803 48 0.8 1276.5 1.0X |
| broadcast nested loop join wholestage on 19142 19214 115 1.1 912.8 1.4X |
| |
| |
