"ADBAAMD" <adba.amdocs@bell.ca> writes:
> More to the point, shouldn't the statistics on tables plus the syntax be
> enough for the planner to get this (not so complex) query a good plan,
> even if not optimal?
We don't generate very good plans for IN at the moment. This is on the
TODO list.
regards, tom lane