Subject Re: Daily Maintenance Task for Firebird
Author Chooi-Ting
--- In, Helen Borrie <helebor@t...>
> At 01:45 AM 8/09/2003 +0000, you wrote:
> >Hi,
> >
> >Just want to check out what are the daily maintenance tasks needed
> >maintain firebird database. Currently I am running 'gbak -B -g'
> >database once a day, and alter index inactive/active. Are them good
> >enough to maintain the performance of the database ?
> Not really. One of the purposes of regular backups is to clear out
> that is left behind by the GC thread and sweeps. The -g switch
> this garbage collection so, if your daily backup always runs with
the -g
> switch, there will be garbage accumulating in space on pages that
> engine could otherwise re-use. Uncollected garbage also causes
searches on
> frequently-accessed tables to take longer and longer over time.
> There's no point in rebuilding indexes unless you need to - you can
> the statistics occasionally to judge the need and the frequency.
> heLen

thanks for your advise. It is my mistake to overlook the -g options.
Without -g switch..the backup will take longer time to complete and
the performance of the database will be effected.