Re: website doc search is extremely SLOW - Mailing list pgsql-general

From Marc G. Fournier
Subject Re: website doc search is extremely SLOW
Date
Msg-id 20031231181039.I42809@ganymede.hub.org
Whole thread Raw
In response to Re: website doc search is extremely SLOW  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: website doc search is extremely SLOW  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: website doc search is extremely SLOW  (Oleg Bartunov <oleg@sai.msu.su>)
Re: website doc search is extremely SLOW  ("Greg Sabino Mullane" <greg@turnstep.com>)
List pgsql-general
On Tue, 30 Dec 2003, Joshua D. Drake wrote:

> Hello,
>
>  Why are we not using Tsearch2?

Because nobody has built it yet?  Oleg's stuff is nice, but we want
something that we can build into the existing web sites, not a standalone
site ...

I keep searching the web hoping someone has come up with a 'tsearch2'
based search engine that does the spidering, but, unless its sitting right
in front of my eyes and I'm not seeing it, I haven't found it yet :(

Out of everything I've found so far, mnogosearch is one of the best ... I
just wish I could figure out where the bottleneck for it was, since, from
reading their docs, their method of storing the data doesn't appear to be
particularly off.  I'm tempted to try their caching storage manager, and
getting away from SQL totally, but I *really* want to showcase PostgreSQL
on this :(

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664

pgsql-general by date:

Previous
From: "Chris Ochs"
Date:
Subject: speeding up inserts
Next
From: Bruce Momjian
Date:
Subject: Re: website doc search is extremely SLOW