search

ydb-platform / ydb

YDB is an open source Distributed SQL Database that combines high availability and scalability with strong consistency and ACID transactions
https://ydb.tech
Apache License 2.0
3.81k stars 521 forks source link

Stream join performance problems #7031

Open ulya-sidorina opened 1 month ago

ulya-sidorina commented 1 month ago

https://datalens.yandex/2ohtijbghz3cq?tab=yV&state=9db7afda195

https://datalens.yandex/2ohtijbghz3cq?tab=yV&state=ab51c3a9366

ulya-sidorina commented 4 weeks ago

Latest perf test results https://datalens.yandex/2ohtijbghz3cq?tab=yV&state=f25ac990160

main with disabled stream join flag + main with enabled stream join flag (results look so similar)

We need to check that stream join was actually used in tpcc tests

ulya-sidorina commented 3 weeks ago

There is one lookup join query in TPCC

ast_with_disabled_flag.txt ast_with_enabled_flag.txt