Skip site navigation (1) Skip section navigation (2)

TODO Item: IN(long list ...)

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: TODO Item: IN(long list ...)
Date: 2006-10-31 20:45:17
Message-ID: 200610311245.17475.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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.

Corrections?

-- 
--Josh

Josh Berkus
PostgreSQL @ Sun
San Francisco

Responses

pgsql-hackers by date

Next:From: Alvaro HerreraDate: 2006-10-31 20:45:24
Subject: Re: TODO Item: IN(long list ...)
Previous:From: Alvaro HerreraDate: 2006-10-31 19:56:59
Subject: Re: [HACKERS] WAL logging freezing

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group