Re: Best way to index large text/varchar fields

Chris Hoover wrote:
> In 8.1, what is the best way to index large text/varchar fields for wild
> card searches?
>
> I am getting good number of queries being submitted for reporting
> purposes that are doing the following - where <text/varchar field> like
> '%some phrase%' and ....
> Is there a good way to index these fields so that the db engine will use
> and index?

If you are indeed using phrases, and thus paragraphs of text, you should
look into Tsearch2.

Joshua D. Drake

>
> Thanks,
>
> Chris

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/