Re: [ADMIN] Full textsearch & gist (fwd)

> ---------- Forwarded message ----------
> Date: Tue, 9 Dec 2003 12:55:55 +0100
> From: Ferdinand Smit <ferdinand@telegraafnet.nl>
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] Full textsearch & gist
>
> Hi,
>
> I'm experimenting with tsearch2. It works very good, but i have a few
> questions:
>
> - Is there a tsearch maillingslist ?
Full information about tsearch v1 and v2 are avaliable at
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/

>
> - How can i create a muticolumn index of an date and a text field, so i for
> example can textsearch in de last few days.
>
> CREATE INDEX test_ix ON test USING gist(date,tsvector);
> ERROR:  data type date has no default operator class for access method "gist"
Install contrib/btree_gist, it contains GiST methods for 'timestamp without time
zone' datatype.


>
> - Does someone now how i can select the most used words, so i can create a
> stop file.
Tsearch v2 has stat function:
select * from stat('select TSVECTOR from TABLE') order by ndoc desc, nentry
desc, word;

Where TSVECTOR is name of column of tsvector type and TABLE is a table with
that column.

Warn: it works very slow.



--
Teodor Sigaev                                  E-mail: teodor@sigaev.ru