Ankit Sharma
@ankitonrocks.bsky.social
Climber, runner, activist living in Squamish, Canada.
Building your favourite data lake at cribl.io | Previously built the fastest object store at AWS-S3
Building your favourite data lake at cribl.io | Previously built the fastest object store at AWS-S3
For each pridicate and each granule (block of 8192 rows by default), it stores a single bit indicating whether any rows in that granule match the condition.
It’s like a lightweight bitmap per predicate.
Since their granules and data parts are immutable, no need to worry about cache staleness.
It’s like a lightweight bitmap per predicate.
Since their granules and data parts are immutable, no need to worry about cache staleness.
April 2, 2025 at 11:38 PM
For each pridicate and each granule (block of 8192 rows by default), it stores a single bit indicating whether any rows in that granule match the condition.
It’s like a lightweight bitmap per predicate.
Since their granules and data parts are immutable, no need to worry about cache staleness.
It’s like a lightweight bitmap per predicate.
Since their granules and data parts are immutable, no need to worry about cache staleness.
The docs on #clickhouse are not super clear about the cache eviction strategy but here’s what I found.
They use their standard SLRU caching policy where older results are removed if they exceed the max allocated memory (default 100MB).
They use their standard SLRU caching policy where older results are removed if they exceed the max allocated memory (default 100MB).
April 2, 2025 at 11:37 PM
The docs on #clickhouse are not super clear about the cache eviction strategy but here’s what I found.
They use their standard SLRU caching policy where older results are removed if they exceed the max allocated memory (default 100MB).
They use their standard SLRU caching policy where older results are removed if they exceed the max allocated memory (default 100MB).
Also… when did Spotify start sneaking in personalized in-podcast ads?! Is it still worth paying for the premium subscription?
March 23, 2025 at 4:54 PM
Also… when did Spotify start sneaking in personalized in-podcast ads?! Is it still worth paying for the premium subscription?