> We have noted a significant (seeming) slow down in the query optimizer from
> 7.3. to 7.4 as it relates to in() clauses. I reviewed some of Tom Lane's
> comments regarding the fact that it was actually optimized specifically - so
> our curiosity has been roused.
Hmmmm .... can we see the query plan in 7.3? The problem appears to be the
left join, not the IN() clause.
Aglio Database Solutions
In response to
sfpug by date
|Next:||From: elein||Date: 2004-01-03 19:53:51|
|Subject: SFPUG meeting at Bucci's|
|Previous:||From: Stephan Szabo||Date: 2003-12-17 20:04:46|
|Subject: Re: Query Optimizer::7.3 to 7.4:: in() problems|