Hi,
We have a table that is sorted according to a column, and we also have a bloom filter on that column. When filtering for many entries (e.g `COLUMN IN (~hundreds of value), instead of just using the bloom filter, the planner spends a lot of time doing "segment init", which I guess is using the prefix index, but doing so ends up costing a lot of time being spent on that.
Does this mean that sorted columns aren't usable if we are filtering for many values?