Subject | Re: [firebird-support] Re: One table become very slow |
---|---|
Author | Ann W. Harrison |
Post date | 2008-09-15T16:42:13Z |
Helen
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
>> How could it be fixed/avoided?Actually, no, the garbage collect work is non-transactional. Once
>
> 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.
>
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