"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> Out of interest Tom, did you optimise the IN (huge list of scalars) case, or
> is it just the IN (subselect) case?
Just IN (subselect). AFAIK, IN (list of scalars) works reasonably well
already... at least for cases where the lefthand side is an indexed
column. What problems are you concerned about?
regards, tom lane