Re: best way to manage indexes - Mailing list pgsql-general

From Scott Marlowe
Subject Re: best way to manage indexes
Date
Msg-id dcc563d10912231805g2fa0c731le2af3ec55c2f6f50@mail.gmail.com
Whole thread Raw
In response to best way to manage indexes  (Jamie Kahgee <jamie.kahgee@gmail.com>)
List pgsql-general
On Wed, Dec 23, 2009 at 3:10 PM, Jamie Kahgee <jamie.kahgee@gmail.com> wrote:
> what would be considered "best practice" for my situation?
> I have a table member, with column name that I want to put an index on,
> because it is searched quiet frequently. When I create my sql search string,
> the name will consist only of alpha-numeric characters and be compared
> against lowercase matches.

SNIP

> perhaps there is a solution that I haven't thought of.  any input would be
> appreciated!

look up full text search.

pgsql-general by date:

Previous
From: Jamie Kahgee
Date:
Subject: best way to manage indexes
Next
From: Craig Ringer
Date:
Subject: Re: best way to manage indexes