I'm on the team who built this, I don't understand how you think these would be used. We need to use a b-tree index to give us ordered results that we then filter by the bloom column, how would an index on the bloom filter column help if we need the ordering?
Context is we didn't think these would work, and did look quite closely. We may have missed something though.
Wait until they find out that Postgres has native bloom filters [0].
0: https://www.postgresql.org/docs/current/bloom.html
I'm on the team who built this, I don't understand how you think these would be used. We need to use a b-tree index to give us ordered results that we then filter by the bloom column, how would an index on the bloom filter column help if we need the ordering?
Context is we didn't think these would work, and did look quite closely. We may have missed something though.
Splunk uses bloom filters to quickly skip buckets that don't contain keywords.