Robert Berger writes:
> Why do the following three queries use different scan types under 7.1.2?
> Under
> 6.5.3 they all used index (and my system ran MUCH faster, since I often
> use the trailing %)
In 7.1, LIKE optimization (i.e., possibly using an index) has been
disabled unless you are in the C locale because it does not work
correctly. You could set your locale to C and re-initdb to get it to work
again.
--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter