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

From Dave Cramer
Subject Re: website doc search is extremely SLOW
Date
Msg-id 1072921727.1662.18.camel@localhost.localdomain
Whole thread Raw
In response to Re: website doc search is extremely SLOW  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: website doc search is extremely SLOW  ("Marc G. Fournier" <scrappy@postgresql.org>)
List pgsql-general
On Wed, 2003-12-31 at 18:43, Bruce Momjian wrote:
> Marc G. Fournier wrote:
> > 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 :(
>
> Well, PostgreSQL is being un-showcased in the current setup, that's for
> sure.  :-(
In fact this is a very bad advertisement for postgres

--
Dave Cramer
519 939 0336
ICQ # 1467551


pgsql-general by date:

Previous
From: Kris Jurka
Date:
Subject: Re: measuring disk usage of records
Next
From: "Marc G. Fournier"
Date:
Subject: Mnogosearch (Was: Re: website doc search is ... )