Subject | Re: [firebird-support] Re: sweep taking a long time |
---|---|
Author | Richard Mace |
Post date | 2005-11-07T11:45:39Z |
> I've also had problems with long running sweep(afterI had deletedWas that after the sweep finished?
> about 1 million records from one table). Eventually following things
> sort problem out:
> 1.gbak -b -g (inhibit garbage collection)
> 2.gbak -r (restore)
> After that sweep took only 1 minute. I think that indices were reason
> for long sweep.
It has been running for about 133 hours, and is still going.
Should i just stop it and do a gbak -b -g and then a gbak?
Thanks