"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 constant pattern for the LIKE or regex match.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
