From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>, "Dave Cramer" <pg(at)fastcrypt(dot)com> |
Cc: | <johnsw(at)wardbrook(dot)com>, "Ericson Smith" <eric(at)did-it(dot)com>, "D(dot) Dante Lorenso" <dante(at)lorenso(dot)com>, <webmaster(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: [webmaster] website doc search is extremely SLOW |
Date: | 2004-01-02 17:11:27 |
Message-ID: | 03AF4E498C591348A42FC93DEA9661B8720352@mail.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> -----Original Message-----
> From: Marc G. Fournier [mailto:scrappy(at)postgresql(dot)org]
> Sent: 31 December 2003 22:20
> To: Dave Cramer
> Cc: johnsw(at)wardbrook(dot)com; Ericson Smith; D. Dante Lorenso;
> webmaster(at)postgresql(dot)org; pgsql-general(at)postgresql(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2004-01-02 17:35:40 | Re: Mnogosearch (Was: Re: website doc search is ... ) |
Previous Message | Nikola Milutinovic | 2004-01-02 15:55:01 | BUG: compiling PL/Python - Semi-SOLVED |