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
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? |