From: Jeff Davis <pgsql@j-davis.com>
To: Madison Kelly <linux@alteeve.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Writting a "search engine" for a pgsql DB
Date: Mon, 26 Feb 2007 12:14:05 -0800
Message-ID: <1172520845.10824.308.camel@dogma.v10.wvs> (raw)
In-Reply-To: <45E30ADA.2050700@alteeve.com>
References: <45E30ADA.2050700@alteeve.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pgsql@j-davis.com, linux@alteeve.com
Subject: Re: Writting a "search engine" for a pgsql DB
In-Reply-To: <1172520845.10824.308.camel@dogma.v10.wvs>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox