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