Postgres Pro
Downloads
Home   >   mailing lists

Search string without tsearch - Mailing list pgsql-admin

From A.Burbello
Subject Search string without tsearch
Date
Msg-id 440310.20885.qm@web36204.mail.mud.yahoo.com
Whole thread Raw
Responses Re: Search string without tsearch  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Re: Search string without tsearch  (Andrew Sullivan <ajs@crankycanuck.ca>)
Re: Search string without tsearch  ("Markus Bertheau" <mbertheau.pg@googlemail.com>)
List pgsql-admin
Tree view 
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 by date:

Previous
From: "Mark Steben"
Date:
Subject: production error
Next
From: "Scott Marlowe"
Date:
Subject: Re: Search string without tsearch