Matt,

Good question. :-)

I don't know if gfix will do garbage collection as well. I don't know if
that line is wrong or not. :-)

Documentation does not talk about Garbage Collection. It just says 'Forces
an immediate sweep of the database'.

What makes sense to me it's that gfix will just do a sweep. Since it will
touch the records, garbage collection will be done. The question remains:
when?

Artur

----- Original Message -----
From: "m_j_mastrangelo" <mmastrangelo@...>
To: <firebird-support@yahoogroups.com>
Sent: Tuesday, August 26, 2003 8:16 PM
Subject: [firebird-support] Re: Sweeping vs. backup & restore


> Artur,
>
> Thanks for your response. That article answered most of my
> questions. It looks like doing a backup and restore convers all my
> bases. Just one thing I wasn't clear on though: the article refers
> to "sweeping" and "garbage collecting" as if they are two separate
> operations. The gfix program, however, would lead one to believe
> that they are the same thing. Here's its description for the -sweep
> parameter:
>
> -sweep force garbage collection
>
> What's the difference between sweep and garbage collect, if any?
>
> Thanks again.
>
> Matt
>
> --- In firebird-support@yahoogroups.com, "Artur Anjos" <artur@a...>
> wrote:
> > Matt,
> >
> > > My question is: do I need to be concerned with sweeping if I am
> > > running a backup/restore regularly?
> >
> > Take a look:
> >
> > http://www.ibphoenix.com/main.nfs?
> a=ibphoenix&l=;IBPHOENIX.KNOWLEDGEBASE;ID='249'
> >
> > This article will answer all your questions.
> >
> > Artur
>