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

From Alvaro Herrera
Subject Re: TODO Item: IN(long list ...)
Date
Msg-id 20061031204524.GE12008@alvh.no-ip.org
Whole thread Raw
In response to TODO Item: IN(long list ...)  (Josh Berkus <josh@agliodbs.com>)
Responses Re: TODO Item: IN(long list ...)
Re: TODO Item: IN(long list ...)
List pgsql-hackers
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?

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: TODO Item: IN(long list ...)
Next
From: Tom Lane
Date:
Subject: Re: TODO Item: IN(long list ...)