From Dev.to
ClickHouse 26.10's string filter during scan cuts a selective LIKE query's memory 25-fold
A LIKE query against ten million rows used 37.6MB of peak memory on ClickHouse 26.9. The same table, the same query, same hardware, on 26.10 released six days ago: 1.48MB. Nothing else about the query...