Re: Writting a "search engine" for a pgsql DB

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: Writting a "search engine" for a pgsql DB
Дата
Msg-id 1172520845.10824.308.camel@dogma.v10.wvs
обсуждение исходный текст
Ответ на Writting a "search engine" for a pgsql DB  (Madison Kelly <linux@alteeve.com>)
Список 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


В списке pgsql-performance по дате отправления:

Предыдущее
От: Mark Stosberg
Дата:
Сообщение: Re: Writting a "search engine" for a pgsql DB
Следующее
От: Ron
Дата:
Сообщение: Re: Vacuumdb - Max_FSM_Pages Problem.