Thread: Re: [webmaster] website doc search is extremely SLOW

Re: [webmaster] website doc search is extremely SLOW

From
"Dave Page"
Date:

> -----Original Message-----
> From: Marc G. Fournier [mailto:scrappy@postgresql.org]
> Sent: 31 December 2003 22:20
> To: Dave Cramer
> Cc: johnsw@wardbrook.com; Ericson Smith; D. Dante Lorenso;
> webmaster@postgresql.org; pgsql-general@postgresql.org
> Subject: Re: [webmaster] [GENERAL] website doc search is
> extremely SLOW
>
> If we pull out the mailing list archives from the database, I
> can't imagine mnogosearch being powerful enough to do it, as
> there really aren't that many pages ... its the archives that
> kill the process ... so maybe we'll just go with that as a
> first step, make 'site search' seperate from 'archives'
> search ... DaveP?  Sound reasonable to try first?

Huh? I don't read -general so have missed most of this. We just finished
merging the search databases because you wanted one single one - you
want them seperated again? What happened about the database monitoring
you were doing? I think we're better off figuring out why things are
slow than simply splitting the databases again (as a first solution we
can add a tag to mark the achives (and other site) entries and then add
a partial index on that tag to logically split them).

Regards Dave.