Horton

Re: Mnogosearch (Was: Re: website doc search is ... )

Marc G. Fournier <scrappy@postgresql.org>

View thread View on postgr.es
From: "Marc G. Fournier" <scrappy@postgresql.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: "Marc G. Fournier" <scrappy@postgresql.org>, Bruce Momjian <pgman@candle.pha.pa.us>, "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Date: 2004-01-01T20:31:04Z
Lists: pgsql-general 
On Thu, 1 Jan 2004, Tom Lane wrote:

> "Marc G. Fournier" <scrappy@postgresql.org> writes:
> > what sort of impact does CLUSTER have on the system?  For instance, an
> > index happens nightly, so I'm guessing that I'll have to CLUSTER each
> > right after?
>
> Depends; what does the "index" process do --- are ndict8 and friends
> rebuilt from scratch?

nope, but heavily updated ... basically, the indexer looks at url for what
urls need to be 're-indexed' ... if it does, it removed all words from the
ndict# tables that belong to that url, and re-adds accordingly ...

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664