Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id EC49C9FB8F2 for ; Mon, 26 Feb 2007 16:14:30 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 36392-06-3 for ; Mon, 26 Feb 2007 16:14:15 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from servata.com (ip-216-152-249-241.servata.com [216.152.249.241]) by postgresql.org (Postfix) with ESMTP id 905FB9FB8E5 for ; Mon, 26 Feb 2007 16:14:15 -0400 (AST) Received: from [209.162.219.253] (helo=dogma.v10.wvs) by servata.com with esmtpa (Exim 4.50) id 1HLmEV-0004Yr-9A; Mon, 26 Feb 2007 12:14:03 -0800 Subject: Re: Writting a "search engine" for a pgsql DB From: Jeff Davis To: Madison Kelly Cc: pgsql-performance@postgresql.org In-Reply-To: <45E30ADA.2050700@alteeve.com> References: <45E30ADA.2050700@alteeve.com> Content-Type: text/plain Date: Mon, 26 Feb 2007 12:14:05 -0800 Message-Id: <1172520845.10824.308.camel@dogma.v10.wvs> Mime-Version: 1.0 X-Mailer: Evolution 2.0.4 (2.0.4-7) Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.185 tagged_above=0 required=5 tests=AWL, BAYES_50, FORGED_RCVD_HELO, SPF_HELO_PASS X-Spam-Level: X-Archive-Number: 200702/310 X-Sequence-Number: 23364 On Mon, 2007-02-26 at 11:29 -0500, Madison Kelly wrote: > I am looking at writing a search engine of sorts for my database. I > have only ever written very simple search engines before which amounted > to not much more that the query string being used with ILIKE on a pile > of columns. This was pretty rudimentary and didn't offer anything like > relevance sorting and such (I'd sort by result name, age or whatnot). Look at Tsearch2: http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ It has a lot of features for searching, and can make use of powerful indexes to return search results very quickly. As someone already mentioned, it also has ranking features. Regards, Jeff Davis