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
