Re: [GENERAL] Please comment on the following OpenFTS/tsearch2 issues!

2006-04-27 Thread Vivek Khera
On Apr 26, 2006, at 3:17 AM, Teodor Sigaev wrote: We knows installation of tsearch2 working with 4 millions docs. What are the design goals for the size of the source tables? My engineers are telling me of things their friends have tried and have hit limits of tsearch2. One was importi

Re: [GENERAL] Please comment on the following OpenFTS/tsearch2 issues!

2006-04-26 Thread Teodor Sigaev
1. While tsearch2 provides fairly complete boolean search expression support with AND - &, OR - |, NOT - !, and grouping - (), OpenFTS appears to only have support for ANDing search terms. Is there some reason it hasn't been extended to support full tsearch2 search expressions? Has anyone modified

Re: [GENERAL] Please comment on the following OpenFTS/tsearch2 issues!

2006-04-25 Thread John DeSoi
On Apr 25, 2006, at 3:45 PM, Don Walker wrote: 2. Neither OpenFTS or tsearch2 support exact phrase matching. I've seen the workaround to support matching a single exact phrase by modifying the WHERE clause with textcolumn ~* "exact phrase". Does this give reasonable performance? It seems

[GENERAL] Please comment on the following OpenFTS/tsearch2 issues!

2006-04-25 Thread Don Walker
This topic was originally posted to the OpenFTS-general list on April 24, 2006. There were no replies in about 22 hours so I'm reposting to this more active list. I'm investigating OpenFTS and tsearch2 to see if they provide enough full-text searching features to be used in a new application. I've