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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
