Date: Tue, 12 Apr 2005 11:30:51 +0400 (MSD)
From: Oleg Bartunov <oleg@sai.msu.su>
To: Dan Feiveson <danf@datajoe.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: OpenFTS
In-Reply-To: <002c01c53ed6$627e1240$fb04030a@CCPlanet.Com>
Message-ID: <Pine.GSO.4.62.0504121126020.16872@ra.sai.msu.su>
References: <002c01c53ed6$627e1240$fb04030a@CCPlanet.Com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed

Dan,

how large is your database ? OpenFTS is what you need because it supports
instant indexing and have access to metadata. I heard about some
large archives up to 10 mln documents, which use OpenFTS. Proper tuning
of database setup in general and OpenFTS is required. In case you want
commercial support you ask me in private mail.

Oleg
On Mon, 11 Apr 2005, Dan Feiveson wrote:

> Hoping someone can provide feedback on integrating OpenFTS into Postgres.
>
> I am running pg 7.3.4 and have a large database of articles that are constantly changing ( being added, updated, removed). I want to perform key word searches across these articles, ranked by relevance and have looked at a number of solutions, including swish-e and ht://dig, but OpenFTS looks like an great solution -- if it works well.
>
> Is anybody using OpenFTS with their pg db and if so how does it perform? Did you encounter any problems installing? Any drawbacks?
>
> Many thanks to anyone with the time to respond,
>
> Dan
>
> Dan Feiveson
> Broomfield, Colorado
>
>

 	Regards,
 		Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83