Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Very large IN-clause is slow, but how to rewrite it?
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Joe Conway <mail(at)joeconway(dot)com>
- Cc: Richard Jones <rich(at)annexia(dot)org>, pgsql-sql(at)postgresql(dot)org
- Subject: Re: Very large IN-clause is slow, but how to rewrite it?
- Date: Sun, 25 Feb 2007 13:34:44 -0500
Joe Conway <mail(at)joeconway(dot)com> writes: > If 8.2, what about > ... WHERE foo IN (select x from (values (1$),(2$),...,(N$)) as t(x)) > ? Well, the OP wasn't using 8.2 --- judging from the selected plan, it had to be 8.0 or older. But yeah, a values-list is an interesting alternative on 8.2. I think actually you don't need all that much extra notation; this seems to work: WHERE foo IN (VALUES ($1),($2),($3),...) regards, tom lane
- Follow-Ups:
- Re: Very large IN-clause is slow, but how to rewrite it?
- From: Richard Jones
- Re: Very large IN-clause is slow, but how to rewrite it?
- References:
- Very large IN-clause is slow, but how to rewrite it?
- From: Richard Jones
- Re: Very large IN-clause is slow, but how to rewrite it?
- From: Tom Lane
- Re: Very large IN-clause is slow, but how to rewrite it?
- From: Joe Conway
- Very large IN-clause is slow, but how to rewrite it?
- Prev by Date: Re: Very large IN-clause is slow, but how to rewrite it?
- Next by Date: Re: Very large IN-clause is slow, but how to rewrite it?
- Previous by thread: Re: Very large IN-clause is slow, but how to rewrite it?
- Next by thread: Re: Very large IN-clause is slow, but how to rewrite it?
- Indexes: