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

From Dave Page
Subject Re: [webmaster] website doc search is extremely SLOW
Date
Msg-id 03AF4E498C591348A42FC93DEA9661B8720352@mail.vale-housing.co.uk
Whole thread Raw
List pgsql-general

> -----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.

pgsql-general by date:

Previous
From: CoL
Date:
Subject: Re: Using indices with long unique IDs.
Next
From: "Gerwin Philippo"
Date:
Subject: Re: Trouble with MsAccess and records above 13000