Re: best way to manage indexes

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: best way to manage indexes
Дата
Msg-id dcc563d10912231805g2fa0c731le2af3ec55c2f6f50@mail.gmail.com
обсуждение исходный текст
Ответ на best way to manage indexes  (Jamie Kahgee <jamie.kahgee@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Jamie Kahgee
Дата:
Сообщение: best way to manage indexes
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: best way to manage indexes