From: Dror Matalon <dror@zapatec.com>
To: pgsql-performance@postgresql.org
Subject: Re: For full text indexing, which is better, tsearch2 or
Date: Wed, 26 Nov 2003 17:03:52 -0800
Message-ID: <20031127010352.GT30893@rlx11.zapatec.com> (raw)
In-Reply-To: <3FC54A82.2040605@familyhealth.com.au>
References: <4c0ccf4c27ff.4c27ff4c0ccf@jhmimail.jhmi.edu>
<3FC54A82.2040605@familyhealth.com.au>
On Thu, Nov 27, 2003 at 08:51:14AM +0800, Christopher Kings-Lynne wrote:
> >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?
>
> I believe I wrote that warning :)
>
> Tsearch2 is what you should use. Yes, it's more complicated but it's
> HEAPS faster and seriously powerful.
>
Can you provide some numbers please, both for creating full text indexes
as well as for searching them? I tried to use tsearch and it seemed like
just creating a full text index on million+ records took forever.
> Just read the README file.
>
> You could also try out the original tsearch (V1), but that will probably
> be superceded soon, now that tsearch2 is around.
>
> Chris
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
--
Dror Matalon
Zapatec Inc
1700 MLK Way
Berkeley, CA 94709
http://www.fastbuzz.comhttp://www.zapatec.com
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: dror@zapatec.com
Subject: Re: For full text indexing, which is better, tsearch2 or
In-Reply-To: <20031127010352.GT30893@rlx11.zapatec.com>
* 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