Re: TSearch2 vs. Apache Lucene - Mailing list pgsql-performance

From Bruce Momjian
Subject Re: TSearch2 vs. Apache Lucene
Date
Msg-id 200512061727.jB6HRVN18473@candle.pha.pa.us
Whole thread Raw
In response to Re: TSearch2 vs. Apache Lucene  (Oleg Bartunov <oleg@sai.msu.su>)
Responses Re: TSearch2 vs. Apache Lucene
Re: TSearch2 vs. Apache Lucene
List pgsql-performance
Oleg Bartunov wrote:
> Folks,
>
> tsearch2 and Lucene are very different search engines, so it'd be unfair
> comparison. If you need full access to metadata and instant indexing
> you, probably, find tsearch2 is more suitable then Lucene. But, if
> you could live without that features and need to search read only
> archives you need Lucene.
>
> Tsearch2 integration into pgsql would be cool, but, I see no problem to
> use tsearch2 as an official extension module. After completing our
> todo, which we hope will likely  happens for 8.2 release, you could
> forget about Lucene and other engines :) We'll be available for developing
> in spring and we estimate about three months for our todo, so, it's
> really doable.

Agreed.  There isn't anything magical about a plug-in vs something
integrated, as least in PostgreSQL.  In other database, plug-ins can't
fully function as integrated, but in PostgreSQL, everything is really a
plug-in because it is all abstracted.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-performance by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: TSearch2 vs. Apache Lucene
Next
From: Ameet Kini
Date:
Subject: postgresql performance tuning