Get the latest tech news
Bloom Filter Indexes in PostgreSQL
F.7. bloom — bloom filter index access method # F.7.1. Parameters F.7.2. Examples F.7.3. Operator Class Interface F.7.4. Limitations F.7.5. Authors …
A Bloom filter is a space-efficient data structure that is used to test whether an element is a member of a set. So index search results must always be rechecked using the actual attribute values from the heap entry. bloom access method doesn't support searching for NULL values.
Or read this on Hacker News
