Re: Efficient Searching of Large Text Fields

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
Cc: Aaron Bono <postgresql(at)aranya(dot)com>, PostgreSQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Efficient Searching of Large Text Fields
Date: 2006-06-14 17:20:41
Message-ID: Pine.GSO.4.63.0606142119450.10866@ra.sai.msu.su
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-sql

On Wed, 14 Jun 2006, Achilleus Mantzios wrote:

> O Oleg Bartunov ?????? ???? Jun 14, 2006 :
>
>> Don't invent a wheel and use contrib/tsearch2 for that.
>
> Hi Oleg,
>
> i just wanted to ask if anything close to
> exact phrase matching could be deployed/implemented with tsearch2.

not yet, but doable, since we have inverted index support now.
Looking for sponsorship.

>
>>
>> On Tue, 13 Jun 2006, Aaron Bono wrote:
>>
>>> In another post on a different topic, Rod Taylor said the following:
>>>
>>> "A\tcat in the\nhat" might be stored as ARRAY['A', 'cat', 'in', 'the',
>>> 'hat'].
>>>
>>> This got me thinking. I have a discussion forum for gamers and want
>>> to provide searching capabilities so the user can type in a phrase
>>> like "magical bow" and get all posts, sorted by relevance that contain
>>> these words.
>>>
>>> My questions are:
>>> 1. Will storing the posts in an ARRAY help improve performance of
>>> these searches? If so, by how much?
>>> 2. What functions or libraries are available to make such searching
>>> easy to implement well?
>>> 3. What is the best way to sort by relevance?
>>>
>>> Thanks,
>>> Aaron Bono
>>>
>>> ---------------------------(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
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 4: Have you searched our list archives?
>>
>> http://archives.postgresql.org
>>
>
>

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Alexis Palma Espinosa 2006-06-14 18:02:55 About sequences that works BAD !!!!
Previous Message Mark Adan 2006-06-14 16:24:28 Re: Good examples of calling slony stored procedures