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@sai.msu.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@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
