Subject RE: [firebird-support] Re: Backing up (gbak) slows other operations
Author Alan McDonald
> Alan, there should not be a lot of garbage (at least none is created
> intentionally). Doing a sweep only reduces the size of the file
> minimally, which suggests to me that there is not much garbage to collect.

sweep does nothing to disk space. Do a restore and compare the real with the
newly resotred copy.

> However, trying gbak without the garbage collection is certainly a
> good suggestion and I will definitely try it... thanks for the advice!
> The use is 24x7. It is not uniform throughout the day, things tend to
> be quieter at night, which is why the backup is scheduled for 4 am...
> that's as "low use" as it gets.
> --- In, "Alan McDonald" <alan@m...>
> wrote:
> > if there's a lot of garbage (created by your app or by design), and
> you are
> > backing up with garbage collection, then this will be CPU intensive.
> > So you need to look at your app to see if you are creating unwanted
> large
> > amounts of garbage, and you need to gbak without collection.
> > Is this 24x7 heavy use? or can you schedule gbaks for low use
> periods? There
> > are a couple of good gbak schedulers around.
> > Alan