Forum OpenACS Q&A: Re: Search indexer slows down entire OACS?

Collapse
Posted by Helge Wilker on
Thank you for your hints. My OpenFTS had that bug indeed, however, the indexing did not finish and the machine continued to be heavily loaded.

I tried moving the entries from search_observer_queue, but that did not help either. As a last resort, I truncated the static_pages table and disabled the "Static pages" package.

The machine load is back to zero now -- page loads, especially for admin pages, are still very slow, though. I guess I'll have to hunt for some tuning tricks now. And I do hope that having the database on a RAID-5 file system was not such a bad idea...

Cheers,
Helge

Collapse
Posted by Jeff Davis on
Did you do a vacuum after doing the big insert?
I guess it's too late now but that might have helped.