On Jan 28, 2008 11:38 AM, A.Burbello <burbello3000(at)yahoo(dot)com(dot)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?
In response to
pgsql-admin by date
|Next:||From: dx k9||Date: 2008-01-28 20:37:58|
|Subject: Zen and art if WAL and dump file mainteance|
|Previous:||From: A.Burbello||Date: 2008-01-28 17:38:15|
|Subject: Search string without tsearch|