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 to work well for me, but I'm sure the results are highly
data dependent. Performance will directly depend on the size and
number of documents you must sequentially search for your phrase
after making the initial cut on the indexed words.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL