Re: 8.0 collate and index use

Richard Greenwood wrote:

>I figure the index non-use issue is due to collate and/or ctype, so I:
>   initdb --locale=C --lc-collate=C
>and indexes are now being used as expected.
>
>Did I address it in the best manner?
>  
>

Yes, I think so.

>Did I overlook anything that should have been obvious? 
>  
>

Not that I know of

>Should a new windows postgres user be expected to spot this and address it? 
>  
>

It is not specifically a Windows issue - it has bitten me on Unix. And 
it is mentioned in the FAQ iirc.

cheers

andrew


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html