From: LIANHE SHAO <lshao2@jhmi.edu>
To: pgsql-performance@postgresql.org
Subject: For full text indexing, which is better, tsearch2 or fulltextindex
Date: Wed, 26 Nov 2003 20:06:02 +0000 (GMT)
Message-ID: <4c0ccf4c27ff.4c27ff4c0ccf@jhmimail.jhmi.edu> (raw)
Hi all,
Which one is better (performance/easier to use),
tsearch2 or fulltextindex?
there is an example how to use fulltextindex in the
techdocs, but I checked the contrib/fulltextindex
package, there is a WARNING that fulltextindex is
much slower than tsearch2. but tsearch2 seems
complex to use, and I can not find a good example.
Which one I should use? Any suggestions?
thanks and Regards,
William
----- Original Message -----
From: Hannu Krosing <hannu@tm.ee>
Date: Wednesday, November 26, 2003 5:33 pm
Subject: Re: [PERFORM] why index scan not working
when using 'like'?
> Tom Lane kirjutas T, 25.11.2003 kell 23:29:
> > Josh Berkus <josh@agliodbs.com> writes:
> > > In regular text fields containing words, your
problem is
> solvable with full
> > > text indexing (FTI). Unfortunately, FTI is
not designed for
> arbitrary
> > > non-language strings. It could be adapted,
but would require a
> lot of
> > > hacking.
> >
> > I'm not sure why you say that FTI isn't a usable
solution. As
> long as
> > the gene symbols are separated by whitespace or
some other non-
> letters> (eg, "foo mif bar" not "foomifbar"), I'd
think FTI would
> work.
> If he wants to search on arbitrary substring, he
could change
> tokeniserin FTI to produce trigrams, so that
"foomifbar" would be
> indexed as if
> it were text "foo oom omi mif ifb fba bar" and
search for things like
> %mifb% should first do a FTI search for "mif" AND
"ifb" and then
> simpleLIKE %mifb% to weed out something like "mififb".
>
> There are ways to use trigrams for 1 and 2 letter
matches as well.
>
> -------------
> Hannu
>
>
> ---------------------------(end of
broadcast)-----------------------
> ----
> TIP 3: if posting/reading through Usenet, please
send an appropriate
> subscribe-nomail command to
majordomo@postgresql.org so that
> your message can get through to the mailing
list cleanly
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: lshao2@jhmi.edu
Subject: Re: For full text indexing, which is better, tsearch2 or fulltextindex
In-Reply-To: <4c0ccf4c27ff.4c27ff4c0ccf@jhmimail.jhmi.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox