Re: Search string without tsearch - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: Search string without tsearch
Date
Msg-id dcc563d10801281041p1aaccf69s5f571b9eefa47460@mail.gmail.com
Whole thread Raw
In response to Search string without tsearch  ("A.Burbello" <burbello3000@yahoo.com.br>)
List pgsql-admin
On Jan 28, 2008 11:38 AM, A.Burbello <burbello3000@yahoo.com.br> wrote:
> 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???

Would pointing out to the PHBs that tsearch was integrated into pgsql
with v8.3 help convince them to stop being reactionary idiots?

pgsql-admin by date:

Previous
From: "A.Burbello"
Date:
Subject: Search string without tsearch
Next
From: dx k9
Date:
Subject: Zen and art if WAL and dump file mainteance