Re: TODO Item: IN(long list ...) - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: TODO Item: IN(long list ...)
Date
Msg-id 200611150112.kAF1CFw11231@momjian.us
Whole thread Raw
In response to Re: TODO Item: IN(long list ...)  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
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. +


pgsql-hackers by date:

Previous
From: "Alon Goldshuv"
Date:
Subject: Re: Segmentation fault with HEAD.
Next
From: Rune Bromer
Date:
Subject: Re: Segmentation fault with HEAD.