Re: contrib/fulltextindex

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Tomas Lehuta <lharp(at)aurius(dot)sk>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: contrib/fulltextindex
Date: 2002-07-22 08:30:09
Message-ID: Pine.GSO.4.44.0207221129060.7568-100000@ra.sai.msu.su
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

It's known problem with LIKE and non-C locale.
You may try contrib/tsearch for full text search. It's works with
locale and does index search.

Oleg
On Mon, 22 Jul 2002, Tomas Lehuta wrote:

> Hello!
>
> i've got a question on my problem..
> i'm using contrib/fulltextindex to index my tables to do a fulltext search
> but i'm using a non-default locale settings on my database.
> i found out that if the locale is default 'C' then fulltextindex tables are
> scanned very fast using btree indices. for sure, i'm using prefix match
> (string ~ '^blabla') which is supposed to scan the table in this way.. so
> it's ok!
> but if i change to different locale (i.e. sk_SK or cs_CZ) the fti table is
> scanned sequentially and it's very slow.. so, the more words are there in my
> fti table and the more more words i'm trying to search at once using table
> join the slower is the search..
>
> so my question is.. is this a bug or the prefix match is not supported to
> perform a table scan using indices under non-default locale?
> please, give me a hint..
>
> regards
>
> Tomas Lehuta
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Vince Vielhaber 2002-07-22 09:48:03 Re: pgbash-2.4a.2 released
Previous Message Tomas Lehuta 2002-07-22 07:37:46 contrib/fulltextindex