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