Re: WHERE IN (subselect) versus WHERE IN (1,2,3,)

Kevin Goess <kgoess@bepress.com> writes:
> Thanks for looking into it, Tom.  We're using 9.0.4, so that might indeed
> be the problem. What additional data (if any) would you like to see?

Well, the first thing to do is update to 9.0.latest and see if the plan
changes.  There are plenty of good reasons to do that besides this
issue; see the release notes.

            regards, tom lane