Best way to index large text/varchar fields

From: "Chris Hoover" <revoohc(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Best way to index large text/varchar fields
Date: 2006-06-09 15:45:23
Message-ID: 1d219a6f0606090845q62fad204m95e526effb35fba1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jeff Frost 2006-06-09 16:21:12 Re: pg_dumpall 8.1.4 large objects error
Previous Message Dirk Lutzebäck 2006-06-09 15:27:47 Re: How to set the global OID counter? COPY WITH OIDS does