Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: TODO Item: IN(long list ...)
- From: Josh Berkus <josh(at)agliodbs(dot)com>
- To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, pgsql-hackers(at)postgresql(dot)org
- Subject: Re: TODO Item: IN(long list ...)
- Date: Tue, 31 Oct 2006 14:34:21 -0800
Tom, > I think it's pretty much done. Try WHERE foo IN (VALUES (1),(2),...) > if you have so many values that a non-nestloop join seems indicated. Hmmm. Was there a reason not to automate this? Thread link is fine if you can remember the subject line ... I can't find it on archives. > The plain non-VALUES list form is also significantly faster than it > was, but I think it will only result in a bitmap indexscan plan type. Yeah, even bitmapscans break down at 1000 values ... -- --Josh Josh Berkus PostgreSQL @ Sun San Francisco
- References:
- TODO Item: IN(long list ...)
- From: Josh Berkus
- Re: TODO Item: IN(long list ...)
- From: Alvaro Herrera
- Re: TODO Item: IN(long list ...)
- From: Tom Lane
- TODO Item: IN(long list ...)
- Prev by Date: Re: zic data updates
- Next by Date: Design Considerations for New Authentication Methods
- Previous by thread: Re: TODO Item: IN(long list ...)
- Next by thread: zic data updates
- Indexes: