X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 0AE489FA5C8 for ; Wed, 14 Jun 2006 14:21:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 39209-08 for ; Wed, 14 Jun 2006 14:21:08 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from ra.sai.msu.su (ra.sai.msu.su [158.250.29.2]) by postgresql.org (Postfix) with ESMTP id B830D9F9CAA for ; Wed, 14 Jun 2006 14:21:02 -0300 (ADT) Received: from ra (ra [158.250.29.2]) by ra.sai.msu.su (8.13.4/8.13.4) with ESMTP id k5EHKfVb028315; Wed, 14 Jun 2006 21:20:42 +0400 (MSD) Date: Wed, 14 Jun 2006 21:20:41 +0400 (MSD) From: Oleg Bartunov X-X-Sender: megera@ra.sai.msu.su To: Achilleus Mantzios cc: Aaron Bono , PostgreSQL Subject: Re: Efficient Searching of Large Text Fields In-Reply-To: Message-ID: References: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/165 X-Sequence-Number: 25401 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