Re: Bloom filters bloom filters bloom filters - Mailing list pgsql-hackers

From pg@thetdh.com
Subject Re: Bloom filters bloom filters bloom filters
Date
Msg-id W9838225735108811263998929@webmail9
Whole thread Raw
In response to Bloom filters bloom filters bloom filters  (Greg Stark <stark@mit.edu>)
List pgsql-hackers
> Then your union operation is to just bitwise or the two bloom filters.

Keep in mind that when performing this sort of union between two comparably-sized sets, your false-positive rate will increase by about an order of magnitude.  You need to size your bloom filters accordingly, or perform the union differently.  Intersections, however, behave well.

There is a similar problem, among others, with expanding smaller filters to match larger ones.

David Hudson

pgsql-hackers by date:

Previous
From: Gabriele Bartolini
Date:
Subject: Re: MySQL-ism help patch for psql
Next
From: Robert Haas
Date:
Subject: Re: lock_timeout GUC patch