Re: [PERFORM] IN() Optimization issue in 8.0rc5

2005-01-15 Thread Tom Lane
Josh Berkus josh@agliodbs.com writes: dm=# explain dm-# SELECT personid FROM mr.person_attributes_old dm-#WHERE personid NOT IN (SELECT personid FROM mr.person_attributes); QUERY PLAN

Re: [PERFORM] IN() Optimization issue in 8.0rc5

2005-01-15 Thread Josh Berkus
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