Alvaro Herrera wrote: > Josh Berkus wrote: > > 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. > > Hmm, wasn't there some work on this regard in 8.2?
Yes. It was fixed by Joe Conway when it was discovered, so never made it on the TODO list. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly