From: Oleg Bartunov <oleg@sai.msu.su>
To: Dan Feiveson <danf@datajoe.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: OpenFTS
Date: Tue, 12 Apr 2005 11:30:51 +0400 (MSD)
Message-ID: <Pine.GSO.4.62.0504121126020.16872@ra.sai.msu.su> (raw)
In-Reply-To: <002c01c53ed6$627e1240$fb04030a@CCPlanet.Com>
References: <002c01c53ed6$627e1240$fb04030a@CCPlanet.Com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: oleg@sai.msu.su, danf@datajoe.com
Subject: Re: OpenFTS
In-Reply-To: <Pine.GSO.4.62.0504121126020.16872@ra.sai.msu.su>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox