On Sat, 2008-06-07 at 08:59 -0500, Adam Rich wrote: > what's faster on one dbms my be different than another. I've found > that postgresql is usually slower than other databases for IN () > queries, but handles EXISTS and inner joins (a third way of writing > your queries above) quite quickly. Do you have an explanation for the slow IN performance? Do you mean Postgres is slow with a value list or a subquery or both? Is it because the execution of a particular plan is slow, or does some good plan not exist in Postgres? Regards, Jeff Davis