Re: [ANNOUNCE] Searching http://www.postgresql.org ... - Mailing list pgsql-announce

From Hannu Krosing
Subject Re: [ANNOUNCE] Searching http://www.postgresql.org ...
Date
Msg-id 38792188.A053A472@tm.ee
Whole thread Raw
In response to Searching http://www.postgresql.org ...  (The Hermit Hacker <scrappy@hub.org>)
Responses Re: [ANNOUNCE] Searching http://www.postgresql.org ...  (The Hermit Hacker <scrappy@hub.org>)
List pgsql-announce
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 ;)

----------
Hannu

pgsql-announce by date:

Previous
From: The Hermit Hacker
Date:
Subject: Searching http://www.postgresql.org ...
Next
From: Hannu Krosing
Date:
Subject: Re: [ANNOUNCE] Searching http://www.postgresql.org ...