Re: indexes on text columns

On Thu, 4 Oct 2001, Martins Zarins wrote:

> I'm using 7.1.3 with --enable-locale
> my locale is lv_LV.ISO8859-13
> And sort works prety fine.
>
> I have a table with text column and index in it.
> When I make some
> EXPLAIN select id from text_table where text_column = 'some_text'
> it reports that sequential scan will be used
> BUT
> When I recompile postgres WITHOUT --enable-locale, index scan ir
> working fine, but sort don't.
>
> Is this a bug or I missed some configuration about locale and
> indeces?

Hmm, did you vacuum analyze both of them? What is explain giving
for the estimated row counts? AFAIKnew, that should have been fine
(although I've never used the locale stuff).