Rich,
> We have noted a significant (seeming) slow down in the query optimizer from
> 7.3. to 7.4 as it relates to in() clauses. I reviewed some of Tom Lane's
> comments regarding the fact that it was actually optimized specifically - so
> our curiosity has been roused.
Hmmmm .... can we see the query plan in 7.3? The problem appears to be the
left join, not the IN() clause.
--
-Josh Berkus
Aglio Database Solutions
San Francisco