Subject | Re: garbage collect in backup |
---|---|
Author | c_pradelli |
Post date | 2005-07-08T18:25:11Z |
Thank you very much Ann,
One more question,
I have a database, it size it is about 5 GB and it usually have about
30 active connection with heavy load, I need to do 2 backups over the
day.
If I do the backup with the -g switch would be impact less in server
performance than without it?
Best regards
Christian
""Ann W. Harrison"" <aharrison@...> escribió en el mensaje
news:42CEB9C6.7060706@......
One more question,
I have a database, it size it is about 5 GB and it usually have about
30 active connection with heavy load, I need to do 2 backups over the
day.
If I do the backup with the -g switch would be impact less in server
performance than without it?
Best regards
Christian
""Ann W. Harrison"" <aharrison@...> escribió en el mensaje
news:42CEB9C6.7060706@......
> c_pradelli wrote:I'm
>>
>> I have got some question about garbage collect and gbak:
>>
>> What is the benefit of do a garbage_collect on the database when
>> doing a backup with gbak?backup,
>
> If you plan to replace the database with one restored from the
> there's no benefit. If not, then removing unneeded back versionsof
> records will improve performance by limiting the growth of thedatabase
> and by avoiding the cost of garbage collection when the database ismore
> heavily used.other
>
>> Are there any difference in the backup file that I obtain from gbak
>> if I use the -g[arbage_collect] switch or if I don't use it?
>
> None.
>
>> Why garbage_collect is enabled by default in gbak if there are
>> tools (gfix) for doing that explicitly?.either
>
> Garbage collection is enabled by default on all functions of the
> database - all transactions, including read-only transactions
> perform garbage collection or produce lists of work for a separatemore
> garbage collection thread. It's just good housekeeping - life is
> pleasant if you clean up messes as you find them rather thanwaiting
> until the mess is intolerable, then stopping everything and doing a
> massive cleanup.