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

--
Zhenzheruha Kate




Sat, 20 May 2000 11:28:19 +0400 (MSD)
Kate <kate@val.sv.uven.ru>
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

Sat, 20 May 2000 07:28:45 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: contextual search
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
>


Sat, 20 May 2000 12:25:11 -0400
"Mitch Vincent" <mitch@huntsvilleal.com>
Re: contextual search