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
