Re: [webmaster] website doc search is extremely SLOW
От | Dave Page |
---|---|
Тема | Re: [webmaster] website doc search is extremely SLOW |
Дата | |
Msg-id | 03AF4E498C591348A42FC93DEA9661B8720352@mail.vale-housing.co.uk обсуждение исходный текст |
Список | 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 по дате отправления: