Sergey Korotkov created IGNITE-24893:
----------------------------------------
Summary: Calcite. TPC-H query #11: performance drop after
IGNITE-24721
Key: IGNITE-24893
URL: https://issues.apache.org/jira/browse/IGNITE-24893
Project: Ignite
Issue Type: Task
Reporter: Sergey Korotkov
After the IGNITE-24721 latency and throughput of TPC-H query #11 drop almost
two times:
| *{color:#000000}{color}* | *{color:#000000}{color}* |
*{color:#000000}{color}* | *{color:#000000}{color}* | *{color:#000000}{color}*
|*{color:#000000}ignite-dev-921d41e285{color}*|*{color:#000000}ignite-dev-601c4ff826{color}*|
|*{color:#000000}benchmark{color}*|*{color:#000000}distr{color}*|*{color:#000000}engine{color}*|*{color:#000000}scale{color}*|*{color:#000000}metric{color}*|*{color:#000000}value{color}*|*{color:#000000}error%{color}*|*{color:#000000}runs#{color}*|*{color:#000000}value{color}*|*{color:#000000}error%{color}*|*{color:#000000}runs#{color}*|*{color:#000000}dif%{color}*|
|{color:#000000}Q11{color}|{color:#000000}True{color}|{color:#000000}calcite{color}|{color:#000000}0.01{color}|{color:#000000}latency_mean_ms{color}|{color:#000000}8.73{color}|{color:#000000}±14.95%{color}|{color:#000000}4{color}|{color:#000000}15.64{color}|{color:#000000}±5.24%{color}|{color:#000000}3{color}|{color:#000000}+79.08%{color}|
|{color:#000000}Q11{color}|{color:#000000}True{color}|{color:#000000}calcite{color}|{color:#000000}0.01{color}|{color:#000000}throughput_rps{color}|{color:#000000}112.95{color}|{color:#000000}±13.99%{color}|{color:#000000}4{color}|{color:#000000}62.93{color}|{color:#000000}±5.26%{color}|{color:#000000}3{color}|{color:#000000}-44.28%{color}|
|{color:#000000}Q11{color}|{color:#000000}True{color}|{color:#000000}calcite{color}|{color:#000000}0.1{color}|{color:#000000}latency_mean_ms{color}|{color:#000000}62.14{color}|{color:#000000}±4.68%{color}|{color:#000000}4{color}|{color:#000000}131.69{color}|{color:#000000}±1.22%{color}|{color:#000000}3{color}|{color:#000000}+111.94%{color}|
|{color:#000000}Q11{color}|{color:#000000}True{color}|{color:#000000}calcite{color}|{color:#000000}0.1{color}|{color:#000000}throughput_rps{color}|{color:#000000}16.05{color}|{color:#000000}±4.96%{color}|{color:#000000}4{color}|{color:#000000}7.60{color}|{color:#000000}±0.00%{color}|{color:#000000}3{color}|{color:#000000}-52.65%{color}|
|{color:#000000}Q11{color}|{color:#000000}True{color}|{color:#000000}calcite{color}|{color:#000000}1.0{color}|{color:#000000}latency_mean_ms{color}|{color:#000000}703.76{color}|{color:#000000}±5.91%{color}|{color:#000000}4{color}|{color:#000000}1,272.75{color}|{color:#000000}±6.47%{color}|{color:#000000}3{color}|{color:#000000}+80.85%{color}|
|{color:#000000}Q11{color}|{color:#000000}True{color}|{color:#000000}calcite{color}|{color:#000000}1.0{color}|{color:#000000}throughput_rps{color}|{color:#000000}1.54{color}|{color:#000000}±17.61%{color}|{color:#000000}4{color}|{color:#000000}0.93{color}|{color:#000000}±30.73%{color}|{color:#000000}3{color}|{color:#000000}-39.30%{color}|
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
