pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedOpenFTS
2+ messages / 2 participants
[nested] [flat]
* OpenFTS
@ 2005-04-11 20:38 Dan Feiveson <danf@datajoe.com>
0 siblings, 1 reply; 2+ messages in thread
From: Dan Feiveson @ 2005-04-11 20:38 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: OpenFTS
@ 2005-04-12 07:30 Oleg Bartunov <oleg@sai.msu.su>
parent: Dan Feiveson <danf@datajoe.com>
0 siblings, 0 replies; 2+ messages in thread
From: Oleg Bartunov @ 2005-04-12 07:30 UTC (permalink / raw)
To: Dan Feiveson <danf@datajoe.com>; +Cc: 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@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-04-12 07:30 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-04-11 20:38 OpenFTS Dan Feiveson <danf@datajoe.com>
2005-04-12 07:30 ` Oleg Bartunov <oleg@sai.msu.su>
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