|Subject||Re: [firebird-support] Backup/Restore vs Reindex|
> From: "Helen Borrie"If you are talking about backup (not restore), than those tasks (cleaning
> gbak does other important housekeeping tasks, especially in cleaning out
> obsolete record versions and freeing up space occupied by the "stumps" of
> deleted rows. It doesn't housekeep indexes.
old versions) are just side effects caused by gbak reading all tables.
The drawback of this method is that it does not move stuck OIT,
and that you are not sure that the cleaning will finish at all since
garbage collect thread will stop when all users disconnects.
Sweep is much better tool for housekeeping.