Re: Can tsearch do some basic text mining

Поиск
Список
Период
Сортировка
От Phoenix Kiula
Тема Re: Can tsearch do some basic text mining
Дата
Msg-id e373d31e0708241815r1505b482ma96c285c721e80d7@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Can tsearch do some basic text mining  (Oleg Bartunov <oleg@sai.msu.su>)
Список pgsql-general
On 25/08/07, Oleg Bartunov <oleg@sai.msu.su> wrote:
> On Fri, 24 Aug 2007, Phoenix Kiula wrote:
>
> > Hi,
> >
> > We have big blobs of text (average 10,000 characters) in a database,
> > from which we would like to discover the most often repeated words or
> > phrases. Can tsearch be used for this kind of pattern search? I
> > suppose it's Text Mining 101 sort of stuff, nothing complex.
>
> there is stat() function, see
> http://www.sai.msu.su/~megera/wiki/Tsearch_V2_Notes
> for more details.
> It's not fast, so better to save results in a table



Thanks. This seems to give words only. How about phrases? If words are
so slow, I shudder to think how long phrase analysis would take -- it
that is possible at all?

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

Предыдущее
От: "Brandon Shalton"
Дата:
Сообщение: Re: [PERFORM] Partioning tsearch2 a table into chunks and accessing via views
Следующее
От: Tom Lane
Дата:
Сообщение: Re: lc_collate issue