>>
>
>
> Ohhh..
>
> Um, completely left field, but, if your items are sequential in some
> way, maybe there is some gross misuse of ranges you could use?
>
> http://www.postgresql.org/docs/9.2/static/rangetypes.html
>
>
> -Andy
>
>
Another thought, for the case of "find all the items in list A but not
list B things can get very slow "
What if you selected everything from list B created yourself a bloom
filter, then selected everything out of list A. (Meaning, take it out
of PG and do the compare yourself)
Or, maybe write yourself a stored proc that could do bloom filters.
-Andy