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: Richard Jones <rich(at)annexia(dot)org>
- Cc: pgsql-sql(at)postgresql(dot)org
- Subject: Re: Very large IN-clause is slow, but how to rewrite it?
- Date: Sun, 25 Feb 2007 11:56:31 -0500
Richard Jones <rich(at)annexia(dot)org> writes: > I've been profiling a PG database / mix of applications and found that > one statement which takes a very long time to execute is: PG 8.2 does better with long IN-lists ... although if the list is so long as to be fetching a significant fraction of the table, you'll still have problems. In that case I'd advise putting the values into a temp table, ANALYZEing same, and doing "WHERE foo IN (SELECT x FROM tmp_table)". regards, tom lane
- Follow-Ups:
- Re: Very large IN-clause is slow, but how to rewrite it?
- From: Joe Conway
- 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
- 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: