Hi,
I have a table with poor bloom filter false ratio:
               SSTable count: 1223
               Space used (live): 726.58 GiB
               Number of partitions (estimate): 8592749
               Bloom filter false positives: 35796352
               Bloom filter false ratio: 0.68472
               Bloom filter space used: 17.82 MiB
               Compacted partition maximum bytes: 386857368

It's a time series, TWCS compaction, window size 1 day, data partitioned in
daily buckets, TTL 2 years.

I have another table with a similar schema, but it is not affected for some
reason:
               SSTable count: 1114
               Space used (live): 329.87 GiB
               Number of partitions (estimate): 25460768
               Bloom filter false positives: 156942
               Bloom filter false ratio: 0.00010
               Bloom filter space used: 54.9 MiB
               Compacted partition maximum bytes: 20924300

Thanks for any advice,

Martin

Reply via email to