"Nick Fankhauser" <nickf@ontko.com> 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 constant pattern for the LIKE or regex match.
regards, tom lane