Re: Bloom filters bloom filters bloom filters

From: pg(at)thetdh(dot)com
To: "<pgsql-hackers(at)postgresql(dot)org>" <pgsql-hackers(at)postgresql(dot)org>
Cc: "Hudson, T(dot) David" <pg1(at)thetdh(dot)com>
Subject: Re: Bloom filters bloom filters bloom filters
Date: 2010-01-20 14:48:49
Message-ID: W9838225735108811263998929@webmail9
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> Then your union operation is to just bitwise or the two bloomfilters.

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

Browse pgsql-hackers by date

  From Date Subject
Next Message Jaime Casanova 2010-01-20 14:54:03 Re: lock_timeout GUC patch
Previous Message Robert Haas 2010-01-20 14:48:26 Re: MySQL-ism help patch for psql