Dan Harris <[EMAIL PROTECTED]> writes:
> query that uses LIKE. In my research I have read that the locale
> setting may affect PostgreSQL's choice of seq scan vs index scan.
Non-C-locale indexes can't support LIKE because the sort ordering
isn't necessarily right.
> I am running Fedora Core 2 a
Greetings,
I have been beating myself up today trying to optimize indices for a
query that uses LIKE. In my research I have read that the locale
setting may affect PostgreSQL's choice of seq scan vs index scan. I am
running Fedora Core 2 and it appears when I run "locale" that it is set
to 'e