| 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: | Whole Thread | Raw Message | 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
| 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 ... |
| 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 ... |