I think it's fair to say that out of the box and RPM install should not
result in indexes not being used because the LANG is set to something
other than 'C'. I'm all for reading the manual and tuning later, but
that is something that can't be changed without a complete
dump/initdb/restore. It's just always seemed kind of misleading to me..
-jj-
On Mon, 2004-01-26 at 13:51, Martín Marqués wrote:
> Mensaje citado por Jeremiah Jahn <jeremiah@cs.earlham.edu>:
>
> > although it will be taken care of, make sure that initdb sets the local
> > language to C or your string indexes will not be used.. Unless this has
> > been fixed and en_US works as as well?
>
> I think that if you really need very fast indexes, the first thing to do is read
> the instalation manual and configure very carefully the postgres acount
> (envioronment variables, etc).
--
Jeremiah Jahn <jeremiah@cs.earlham.edu>