Search string without tsearch

Поиск
Список
Период
Сортировка
Hi people,

I would like to some suggestion to search person name
in a table that has more than 150 milions of rows ...

e.g ... name like 'JOHN%SMITH';

I know there is contrib Tsearch, but I can't for
political reasons.
Is there any way to do with good performance???

Thank you.


      Abra sua conta no Yahoo! Mail, o único sem limite de espaço para armazenamento!
http://br.mail.yahoo.com/

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Mark Steben"
Дата:
Сообщение: production error
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Search string without tsearch