| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
| Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: TODO Item: IN(long list ...) |
| Date: | 2006-11-15 01:12:15 |
| Message-ID: | 200611150112.kAF1CFw11231@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alon Goldshuv | 2006-11-15 01:26:19 | Re: Segmentation fault with HEAD. |
| Previous Message | Bruce Momjian | 2006-11-15 01:10:28 | Re: [HACKERS] Replication documentation addition |