Re: TSearch vs. Homebrew

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Hannes Dorbath <light(at)theendofthetunnel(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: TSearch vs. Homebrew
Date: 2006-06-27 11:31:09
Message-ID: Pine.GSO.4.63.0606271527110.2921@ra.sai.msu.su
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christian Rengstl 2006-06-27 11:43:21 Question concerning arrays
Previous Message Alban Hertroys 2006-06-27 11:15:10 Anonymous PL functions?