Tsearch2 or openFTS ?

OpenFTS vs Tsearch2

OpenFTS is a middleware between application and database, so it uses
tsearch2 as a storage, while database engine is used as a query executor
(searching). Everything else (parsing of documents, query processing,
linguistics) carry outs on client side. That's why OpenFTS has its own
configuration table (fts_conf) and works with its own set of dictionaries.
OpenFTS is more flexible, because it could be used in multi-server
architecture with separated machines for repository of documents
(documents could be stored in file system), database and query engine.

psql-mail@freeuk.com wrote:

While I continue trying to get tsearch2 up and running...

When should a db designer opt for tsearch2 directly and when should
they opt for openFTS?

--
Teodor Sigaev E-mail: teodor@sigaev.ru