Subject Re: [firebird-support] Re: One table become very slow
Author Ann W. Harrison
Helen
>> How could it be fixed/avoided?
>
> Don't keep stopping gbak when it's in the process of garbage-collecting
> your problem table!!! It hasn't "hung", it is just very, very busy.
> If you terminate gbak, all that GC work will be rolled back.
>

Actually, no, the garbage collect work is non-transactional. Once
it's done, it stays done. Which is fine, from a theoretical point
of view, because the garbage is of no interest to any running
transaction - that's why we call it "garbage". Still that database
is full of the stuff.

Cheers,

Ann