Search string without tsearch

From: "A(dot)Burbello" <burbello3000(at)yahoo(dot)com(dot)br>
To: Postgres Adm List <pgsql-admin(at)postgresql(dot)org>
Subject: Search string without tsearch
Date: 2008-01-28 17:38:15
Message-ID: 440310.20885.qm@web36204.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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/

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2008-01-28 18:41:12 Re: Search string without tsearch
Previous Message Mark Steben 2008-01-28 17:21:34 production error