| ================================================================================================ |
| Join Benchmark |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 21.0.8+9-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 2144 2152 11 9.8 102.2 1.0X |
| Join w long wholestage on 913 938 19 23.0 43.5 2.3X |
| |
| OpenJDK 64-Bit Server VM 21.0.8+9-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 2025 2029 6 10.4 96.6 1.0X |
| Join w long duplicated wholestage on 947 997 28 22.1 45.2 2.1X |
| |
| OpenJDK 64-Bit Server VM 21.0.8+9-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 108340 108384 62 0.2 5166.1 1.0X |
| Join w 2 ints wholestage on 106411 106556 130 0.2 5074.1 1.0X |
| |
| OpenJDK 64-Bit Server VM 21.0.8+9-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 3530 3550 28 5.9 168.3 1.0X |
| Join w 2 longs wholestage on 1968 1989 14 10.7 93.8 1.8X |
| |
| OpenJDK 64-Bit Server VM 21.0.8+9-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 8952 9029 109 2.3 426.8 1.0X |
| Join w 2 longs duplicated wholestage on 5694 5767 67 3.7 271.5 1.6X |
| |
| OpenJDK 64-Bit Server VM 21.0.8+9-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 1574 1576 3 13.3 75.1 1.0X |
| outer join w long wholestage on 934 993 102 22.4 44.6 1.7X |
| |
| OpenJDK 64-Bit Server VM 21.0.8+9-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 1060 1063 4 19.8 50.6 1.0X |
| semi join w long wholestage on 555 578 15 37.8 26.5 1.9X |
| |
| OpenJDK 64-Bit Server VM 21.0.8+9-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 507 514 9 4.1 241.8 1.0X |
| sort merge join wholestage on 461 468 6 4.5 219.8 1.1X |
| |
| OpenJDK 64-Bit Server VM 21.0.8+9-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 1013 1015 2 2.1 483.0 1.0X |
| sort merge join with duplicates wholestage on 921 931 10 2.3 439.0 1.1X |
| |
| OpenJDK 64-Bit Server VM 21.0.8+9-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 516 528 17 8.1 123.1 1.0X |
| shuffle hash join wholestage on 370 391 17 11.3 88.3 1.4X |
| |
| OpenJDK 64-Bit Server VM 21.0.8+9-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 25481 25537 80 0.8 1215.0 1.0X |
| broadcast nested loop join wholestage on 17573 17808 226 1.2 838.0 1.4X |
| |
| |
