| 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