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

Collapse
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

Collapse
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