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


	The Toolkit for Online Communities 15889 Community Members, 0 members online, 1827 visitors today			Log In	Register

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

OpenACS Home : Forums : OpenACS Q&A : Re: Search indexer slows down entire OACS? : One Message

Back to OpenACS Q&A

7: Re: Search indexer slows down entire OACS? (response to 1)

Posted by Helge Wilker on 12/12/02 02:16 PM

Yes, VACUUM... I must have been dreaming about "VACUUM not necessary anymore in PostgreSQL". Of course it was too late when I thought about vacuuming the database. Now I'm in the middle of uninstalling "Static pages" completely (the automatic uninstall broke).

My plan is to try all this (installing "Static pages", creating static content, indexing it, ...) again with a somewhat smaller set of data.

Again, thanks for your help!

Cheers,
Helge

8: Re: Search indexer slows down entire OACS? (response to 7)

Posted by Bart Teeuwisse on 12/16/02 06:05 AM

Hmmm. This might be an old bug resurfacing. I'm running OpenACS 4.6 with OpenFTS 0.3.2 in combination with PG 7.3. And I'm experiencing the exact same problem:

Cannot insert a duplicate key into unique index index10_key

I've verified that this not caused by the OpenFTS 0.2 bug. Moreover, I'm experiencing this problem with both OpenFTS 0.3.1 and 0.3.2.

It turns out that I'm only experiencing this problem in PG 7.3. Dan, have you tried OpenFTS with PG 7.3?

/Bart

Back to OpenACS Q&A