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
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 and
