ClickHouse 26.10's string filter during scan cuts a selective LIKE query's memory 25-fold
DEV Community
ClickHouse 26.10's string filter during scan cuts a selective LIKE query's memory 25-fold
I benchmarked ClickHouse 26.10's new apply_string_filters_during_scan setting against 26.9: a selective LIKE query's peak memory dropped from 37.6MB to 1.5MB, but a plain WHERE equality got none of it until I rewrote it as PREWHERE.
0 comments
No comments yet.