Thread: indexes on text columns

indexes on text columns

From
"Martins Zarins"
Date:
Hi , all!

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?

Mark

Re: indexes on text columns

From
Stephan Szabo
Date:
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).