Subject | Re: [firebird-support] Re: What's the difference between "Gbak -g" and "gFix -sweep" |
---|---|
Author | Ann W. Harrison |
Post date | 2008-05-04T17:54:16Z |
svanderclock wrote:
to the null device, but it's still going to go over all data,
metadata, and procedural objects and try to make a copy of them
that can be restored. Second, gfix -sweep resets the value of
the "oldest interesting transaction". That reduces the cost
of some internal bookkeeping.
If you want both effects, setting the oldest interesting
transaction to the oldest transaction that was running when
the sweep started and creating a backup file, you could run
the sweep first then a gbak with -g since there will be
little or nothing to garbage collect.
Regards,
Ann
>No. First, gbak creates a backup file. You could direct that
> I want to ask if :
>
> Gbak (without -g)
> and
> "gFix -sweep
>
> ABSOLUTELY IDENTICAL ?
>
to the null device, but it's still going to go over all data,
metadata, and procedural objects and try to make a copy of them
that can be restored. Second, gfix -sweep resets the value of
the "oldest interesting transaction". That reduces the cost
of some internal bookkeeping.
If you want both effects, setting the oldest interesting
transaction to the oldest transaction that was running when
the sweep started and creating a backup file, you could run
the sweep first then a gbak with -g since there will be
little or nothing to garbage collect.
Regards,
Ann