Subject Re: AW: [firebird-support] VACUUM
Author Faisal Abdullah
Thanks for your responses.

From this site ( ), I find
the following command to turn *off* automatic sweeping.:
gfix -user SYSDBA -password masterkey dbserver:/db/mydb.fdb -h 0
Is automatic sweeping configured by default? How can I see the configuration?

If I run the following command (I believe its to 'sweep database
now'), will it turn *on* automatic sweeping? I can't seem to find how
to turn automatic sweeping on (considering if this command doesn't).
gfix -user SYSDBA -password masterkey dbserver:/db/mydb.fdb -s

Faisal Abdullah

On Fri, 15 Oct 2004 19:23:49 +1000, Helen Borrie <helebor@...> wrote:
> At 11:10 AM 15/10/2004 +0200, you wrote:
> >Hi
> >
> > > > Hi, is there a way to vacuum or reorganise tables?
> > > Reclaiming unused spaced is done automatically by the "Garbage
> >collection".
> Actually, not altogether. GC will release space that was occupied by old
> record versions back to the database, for subsequent re-use for new
> versions of records belonging to the same table. GC does not perform this
> task for space that was occupied by records that have been deleted. Use
> sweep for that.
> > This is the same thing that "VACUUM" on an PostgreSQL database
> >does perform.
> Judging by the semantic similarity of the words "sweep" and "vacuum", and
> the fact that PG copied MGA from Firebird/IB, I'd guess that sweep is the
> closest thing. Possibly PG doesn't do any other sort of GC.
> ./heLen