Re: TSearch vs. Homebrew - Mailing list pgsql-general

From Oleg Bartunov
Subject Re: TSearch vs. Homebrew
Date
Msg-id Pine.GSO.4.63.0606271527110.2921@ra.sai.msu.su
Whole thread Raw
In response to TSearch vs. Homebrew  (Hannes Dorbath <light@theendofthetunnel.de>)
Responses Re: TSearch vs. Homebrew
List pgsql-general
On Tue, 27 Jun 2006, Hannes Dorbath wrote:

> http://www.symfony-project.com/askeet/21
>
> How does this dead simple approach compare to TSearch performance / scaling
> wise?

You miss the main point in tsearch2 - full integration with database, i.e.,
full access to metadata, ACID.....
Lucene has no of these features, so it could use some well known optimization
and, and so,  scales better. If you don't need ACID, metadata access, why
do you need database at all ?

     Regards,
         Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Anonymous PL functions?
Next
From: "Christian Rengstl"
Date:
Subject: Question concerning arrays