Tom,
> Hmm. What you want for a NOT IN is for it to say
> Filter: (NOT (hashed subplan))
> which you are not getting. What's the datatypes of the two personid
> columns?
INT
> Is the 400k-row estimate for person_attributes reasonable?
Yes, the estimates are completely accurate.
> Maybe you need to increase work_mem (nee sort_mem) to allow a
> 400k-row hash table?
Aha, that's it. I thought I'd already set that, but apparently it was a
different session. Fixed. Thanks!
--
Josh Berkus
Aglio Database Solutions
San Francisco