Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Best way to index large text/varchar fields
- From: "Joshua D. Drake" <jd(at)commandprompt(dot)com>
- To: Chris Hoover <revoohc(at)gmail(dot)com>
- Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
- Subject: Re: Best way to index large text/varchar fields
- Date: Fri, 09 Jun 2006 09:24:47 -0700
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/
- References:
- Best way to index large text/varchar fields
- From: Chris Hoover
- Best way to index large text/varchar fields
- Prev by Date: Re: pg_dumpall 8.1.4 large objects error
- Next by Date: Re: pg_dumpall 8.1.4 large objects error
- Previous by thread: Best way to index large text/varchar fields
- Next by thread: Major Problems with PostgreSQL Logs (8.1.3)
- Indexes: