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 bruce@momjian.us
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 majordomo@postgresql.org so that your
message can get through to the mailing list cleanly