"Nick Fankhauser" <[EMAIL PROTECTED]> writes:
> ... In addition, since we're using a "like", typing
> in only an initial char would get roughly 1/26 of the rows back- Does the
> planner look at the number of leading chars provided when coming up with a
> plan?
Yeah it does, if it can see a consta
> Hmm. If the outer side of the nestloop were actually hitting 2696 rows
> on average, it wouldn't be "lightning fast". So the planner's failure
> to choose this plan is probably due to this overestimate.
This may be a reasonable estimate- as you might have gathered, we're
matching people to c
