Re: best way to manage indexes

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Jamie Kahgee <jamie(dot)kahgee(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: best way to manage indexes
Date: 2009-12-24 02:05:23
Message-ID: dcc563d10912231805g2fa0c731le2af3ec55c2f6f50@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Dec 23, 2009 at 3:10 PM, Jamie Kahgee <jamie(dot)kahgee(at)gmail(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2009-12-24 03:28:16 Re: best way to manage indexes
Previous Message Jamie Kahgee 2009-12-23 22:10:21 best way to manage indexes