simon godden wrote:
I did that, e.g. initdb --locale=C, re-created all my data and have
exactly the same problem.
I have two indexes, one with no options, and one with the varchar
operator options.
So the situation now is:
If I do a like query it uses the index with the varchar options;
If I do a = query, it uses the index with no options;
If I do a < or > or any other operator, it reverts back to a seq-scan!
I am on FC5 - any further ideas? Did I need to do anything specific
about collating sequence? I thought that the --locale=C would set
that for all options.
From psql, a "show all" command will list all your config settings and
let you check the lc_xxx values are correct.
Make sure you've analysed the database after restoring, otherwise it
will have bad stats available.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
