PFC <lists(at)peufeu(dot)com> writes:
> The IN() is quite small (150 values), but the two large tables are
> seq-scanned... is there a way to avoid this ?
Not in 8.1. HEAD is a bit smarter about joins to Append relations.
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Jim C. Nasby||Date: 2006-04-25 18:24:45|
|Subject: Re: planner not using index for like operator|
|Previous:||From: Bill Moran||Date: 2006-04-25 18:14:35|
|Subject: Large (8M) cache vs. dual-core CPUs|