> 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? 


> 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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to