≈ the.bay.news

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

Sign in to join the discussion — your thebay.events account works here.

No comments yet.