From: | Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
---|---|
To: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
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 07:24:11 |
Message-ID: | Pine.LNX.4.44.0606141022400.23479-100000@matrix.gatewaynet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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.
>
> 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
>
--
-Achilleus
From | Date | Subject | |
---|---|---|---|
Next Message | Sergey Levchenko | 2006-06-14 09:09:03 | how to replace 0xe28093 char with another one? |
Previous Message | Oleg Bartunov | 2006-06-14 07:17:19 | Re: Efficient Searching of Large Text Fields |