Re: [SQL] OpenFTS

2005-04-12 Thread Oleg Bartunov
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 s

[SQL] OpenFTS

2005-04-11 Thread Dan Feiveson
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 looke