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). ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
