contextual search

Started by Kateover 25 years ago3 messages
#1Kate
kate@val.sv.uven.ru

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

--
Zhenzheruha Kate

#2Bruce Momjian
pgman@candle.pha.pa.us
In reply to: Kate (#1)
Re: 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
#3Mitch Vincent
mitch@huntsvilleal.com
In reply to: Bruce Momjian (#2)
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

Show quoted text

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