Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: TODO Item: IN(long list ...)
- From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
- To: Josh Berkus <josh(at)agliodbs(dot)com>
- Cc: pgsql-hackers(at)postgresql(dot)org
- Subject: Re: TODO Item: IN(long list ...)
- Date: Tue, 31 Oct 2006 17:45:24 -0300
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.
- Follow-Ups:
- Re: TODO Item: IN(long list ...)
- From: Tom Lane
- Re: TODO Item: IN(long list ...)
- References:
- TODO Item: IN(long list ...)
- From: Josh Berkus
- TODO Item: IN(long list ...)
- Prev by Date: TODO Item: IN(long list ...)
- Next by Date: Re: TODO Item: IN(long list ...)
- Previous by thread: TODO Item: IN(long list ...)
- Next by thread: Re: TODO Item: IN(long list ...)
- Indexes: