You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
q20's bottleneck is also likely to be LeftSemiJoin as it has 2 LeftSemiJoin out of total 4 joins
2024-02-26
after some investigation:
q4's bottleneck is in LeftSemiJoin
Changing the barrier of both systems to 10s and using the latest image, the performance is about the same.
q20's bottleneck is also likely to be LeftSemiJoin as it has 2 LeftSemiJoin out of total 4 joins
The bottleneck is in the subquery, see #14797 for details
1 and 2 remains
2024-02-28
q20 reveals a potential problem in cache eviction strategy: #15305
2024-02-29
q4 also has a very similar observation caused by the cache eviction strategy: #14811 (comment)
Q4's LocalStoreIter::{Closure} takes an substantial amount of CPU time. See threads in the issue of Q4.
See performance numbers at https://www.notion.so/risingwave-labs/TPCH-Performance-Numbers-Table-e098ef82884546949333409f0513ada7?pvs=4#8de0bf4bda51444c8381f3b0c10ddfe1
Improvements needed:
The text was updated successfully, but these errors were encountered: