Re: OpenFTS

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Dan Feiveson <danf(at)datajoe(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: OpenFTS
Date: 2005-04-12 07:30:51
Message-ID: Pine.GSO.4.62.0504121126020.16872@ra.sai.msu.su
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

In response to

  • OpenFTS at 2005-04-11 20:38:13 from Dan Feiveson

Browse pgsql-sql by date

  From Date Subject
Next Message Andrus 2005-04-12 10:09:42 Re: Query runs very slowly in Postgres, but very fast in other DBMS
Previous Message Richard Huxton 2005-04-12 07:30:40 Re: Update aborted if trigger function fails?