Re: query optimizer questions

Peter Eisentraut wrote:

> Allan Engelhardt writes:
>
> > I find locale support in PostgreSQL confusing. The locale of the
> > current user at the time of initialising the database determines the
> > collating order (e.g. is 'a' < 'A'). This in turns affect things like
> > indexing (as described below).
>
> This is because if you were allowed to change this setting after the
> database initialization, your indexes would get corrupted. (Recall that
> (some) indexes are sorted, and the index scanning code relies on indexes
> being sorted a certain way.)

Yes, I understand WHY it is, I just wish it was documented somewhere obvious. But nevermind - that what these mailing lists are for!

Thanks, all.

Allan.