Re: Improve Search

On Fri, 2 Nov 2007, carter ck wrote:

>
> Hm. No. I am not using tsearch2. I have looked at the documentation, but not sure how it benefits me.
>
> I am searching for text such as mobile numbers and user name in my application.
>
> Any idea of having tseach2 to accommodate different search fields? Way of Implementing it will be helpful too.

create custom parser/dictionary would greatly help you.
see dict_regex, for example,
http://lynx.sao.ru/~karpov/software/postgres_dict_regex.html

>
> Thanks.
>
> ----------------------------------------
>> Date: Thu, 1 Nov 2007 22:32:47 -0500
>> From: scott(dot)marlowe(at)gmail(dot)com
>> To: carterck32(at)hotmail(dot)com
>> Subject: Re: [GENERAL] Improve Search
>> CC: pgsql-general(at)postgresql(dot)org
>>
>> On 11/1/07, carter ck wrote:
>>>
>>> Hi all,
>>>
>>> Has anyone come across a solution for faster and powerful search stored procedure in a table that contains more than 500K of records?
>>>
>>> I am currently trying to work around with it. All helps are appreciated.
>>
>> Are you using the tsearch2 full text engine? If not, you're missing
>> the boat for fast searching text. But you didn't really tell us what
>> exactly you're searching on, so I'm just guessing.
>
> _________________________________________________________________
> Manage multiple email accounts with Windows Live Mail!
> http://www.get.live.com/wl/all
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83