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
listsare for! 

Thanks, all.


Allan.