Re: full-text indexing

On Tue, 18 Apr 2000, Bruce Momjian wrote:

> > I agree!  The last bit of advice given in the full text README.  As I
> > said, I'd built full-text stuff for experimentation (I had maybe 30k of
> > raw text, which amounted to several 100,000 indexed entries), and I had
> > clustered it, and it was pretty darn fast, even on a Pentium 233 with only
> > 48 megs of RAM.  I have significantly better hardware to run it on now.
> > The original project called MySQL, but it just didn't have what we needed
> > to put something like this together.
>
> With the original author, testing was fast, but when he loaded all the
> data, it got very slow.  The problem was that as soon as his data
> exceeded the buffer cache, performance became terrible.

How much data are we talking here?  How can one get around this buffer
cache problem?

Brett W. McCoy
                                              http://www.chapelperilous.net
---------------------------------------------------------------------------
Twenty two thousand days.
Twenty two thousand days.
It's not a lot.
It's all you've got.
Twenty two thousand days.
        -- Moody Blues, "Twenty Two Thousand Days"