Bruce, all: This is a longstanding performance issue which just came up again on IRC, and I can't find a TODO item for it. So I'd like it added to TODO. Suggested phrasing:
-- Improve performance of queries with IN() clauses containing hundreds or more literal values, possibly by re-writing it as a join to a virtual table. Corrections? -- --Josh Josh Berkus PostgreSQL @ Sun San Francisco ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq