On Mon, 10 Jan 2000, Hannu Krosing wrote:
> The Hermit Hacker wrote:
> >
> > Well, finally have a good portion of the web site now searchable...the
> > following "sections" of other web site is available:
>
> Having implemented a full-text index myself a few years ago, i tried some
> more taxing queries (those that return most of the pages, and that could
> (should) be banned by stop words or some smarter techniques (like
> partitioning the search space by date or some other attribute first)
>
> the results
>
> of 31220 matches <10 sec
> at 16002 matches <5 sec
> PostgreSQL 24807 matches <10 sec
> I infinite, (maybe computer crash ?, www.postgresql.org also
> unreachable)
>
> please dont sue me ;)
You didn't crash anything, no worry...:)
As for stopwords, they do provide a mechanism for doing this, and, ummm, I
forgot to load it :)
Loaded now, so it should reduce as it gets recycled/expired...I don't want
to start this all from scratch again :(
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: [EMAIL PROTECTED] secondary: scrappy@{freebsd|postgresql}.org
************
