Re: [ANNOUNCE] Searching http://www.postgresql.org ...

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: Hannu Krosing <hannu(at)tm(dot)ee>
Cc: pgsql-announce(at)postgreSQL(dot)org, Alexander Barkov <bar(at)izhcom(dot)ru>, udmsearch(at)web(dot)izhcom(dot)ru, pgsql-general(at)postgreSQL(dot)org
Subject: Re: [ANNOUNCE] Searching http://www.postgresql.org ...
Date: 2000-01-10 00:09:21
Message-ID: Pine.BSF.4.21.0001092002140.18498-100000@thelab.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-announce pgsql-general

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: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org

In response to

Browse pgsql-announce by date

  From Date Subject
Next Message Hannu Krosing 2000-01-10 00:12:58 Re: [ANNOUNCE] Searching http://www.postgresql.org ...
Previous Message Hannu Krosing 2000-01-10 00:02:16 Re: [ANNOUNCE] Searching http://www.postgresql.org ...

Browse pgsql-general by date

  From Date Subject
Next Message Hannu Krosing 2000-01-10 00:12:58 Re: [ANNOUNCE] Searching http://www.postgresql.org ...
Previous Message Hannu Krosing 2000-01-10 00:02:16 Re: [ANNOUNCE] Searching http://www.postgresql.org ...