Postgres Pro
Downloads
Home   >   mailing lists

Best way to index large text/varchar fields - Mailing list pgsql-admin

From Chris Hoover
Subject Best way to index large text/varchar fields
Date
Msg-id 1d219a6f0606090845q62fad204m95e526effb35fba1@mail.gmail.com
Whole thread Raw
Responses Re: Best way to index large text/varchar fields  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-admin
Tree view
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?

Thanks,

Chris

pgsql-admin by date:

Previous
From: Dirk Lutzebäck
Date:
Subject: Re: How to set the global OID counter? COPY WITH OIDS does
Next
From: Jeff Frost
Date:
Subject: Re: pg_dumpall 8.1.4 large objects error