Re: Full Text Index Stats

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Ryan Hansen <ryan(dot)hansen(at)brightbuilders(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Full Text Index Stats
Date: 2008-10-23 06:52:12
Message-ID: Pine.LNX.4.64.0810231050530.15810@sn.sai.msu.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Ryan,

you may take a look on
http://www.sai.msu.su/~megera/postgres/talks/fts84+.pdf
There are slides with examples

Oleg
On Mon, 20 Oct 2008, Ryan Hansen wrote:

> Greetings,
>
>
>
> I couldn't find anything about this in the documentation or the mailing list
> archives, so forgive me if this has already been addressed.
>
>
>
> I'm trying to determine if the full text indexing has any built-in
> capability for providing information about word occurrence, i.e. the number
> of times a given word is used. I read about the ts_stat function, but
> either I don't understand the syntax well enough or I don't think this is
> what I'm looking for. I know it can be used for determining the most used
> words in the index (although this is very slow), but I want to be able to
> get the number of occurrences on a given word. Is that kind of thing
> built in somewhere or do I need to write it myself?
>
>
>
> Thanks!
>
>

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Zied Kharrat 2008-10-23 08:14:25 Postgres-sql-php
Previous Message David Garamond 2008-10-22 05:14:49 grouping/clustering query