Обсуждение: contextual search

Does the PostgreSQL have some features enabling to make contextual search
in fulltexts (something like Oracle Context Option)?

--
Zhenzheruha Kate

> 
> Does the PostgreSQL have some features enabling to make contextual search
> in fulltexts (something like Oracle Context Option)?

Yes, see contrib/fulltextindex.

--  Bruce Momjian                        |  http://www.op.net/~candle pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 

If you use this and have a decent amount of text to index, be prepared to
spend a few days.. I had about 2000 files of Text (varying size) -- it
turned out to be about 600 megs, 33 million rows in the indexed column...
Creating indexes on that and VACUUM 'ing takes hours -- literally.   :-)

Towards the end of the README it describes several ways of clustering your
tables on the disk. Use method two if you have the disk space, it's much
faster than CLUSTER!

Good luck!

-Mitch

----- Original Message -----
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Kate <kate@val.sv.uven.ru>
Cc: <pgsql-hackers@postgresql.org>
Sent: Saturday, May 20, 2000 7:28 AM
Subject: Re: [HACKERS] contextual search


> >
> > Does the PostgreSQL have some features enabling to make contextual
search
> > in fulltexts (something like Oracle Context Option)?
>
> Yes, see contrib/fulltextindex.
>
> --
>   Bruce Momjian                        |  http://www.op.net/~candle
>   pgman@candle.pha.pa.us               |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
>