Forum OpenACS Q&A: Re: 4.5 ticket tracker submission slowing down

Collapse
2: Re: 4.5 ticket tracker submission slowing down (response to 1)
Posted by Jeff Davis on 03/11/03 08:38 AM
Do you vacuum the db periodically? If not try 
vacuumdb -f -z dbname
and see if that helps. Note that under pg 7.1 there are some states the tables get in such that vacuum will fail (you will get a message like "ERROR: No one parent tuple was found"), If that's happened I think your only option is a dump/restore.