| From: | Jeff Davis <pgsql(at)j-davis(dot)com> |
|---|---|
| To: | Madison Kelly <linux(at)alteeve(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Writting a "search engine" for a pgsql DB |
| Date: | 2007-02-26 20:14:05 |
| Message-ID: | 1172520845.10824.308.camel@dogma.v10.wvs |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron | 2007-02-26 20:33:14 | Re: Vacuumdb - Max_FSM_Pages Problem. |
| Previous Message | Mark Stosberg | 2007-02-26 19:46:18 | Re: Writting a "search engine" for a pgsql DB |