Am I correct in understanding that the garbage collection is only effected,
once a restore is performed, after the backup?



Regards



Adrian



_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Adam
Sent: 06 November 2007 01:34 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Firebird and vacuum?



--- In firebird-support@ <mailto:firebird-support%40yahoogroups.com>
yahoogroups.com, "Roman Rokytskyy"
<rrokytskyy@...> wrote:

>
> > PostgreSQL and SQLite have something called vacuum, is there a

similar

> > option for Firebird?
>
> Here it is called garbage collection, happens in background and does
> not require user/admin intervention. It just works.
>

It should be pointed out that backing up the database performs garbage
collection at the same time (unless you explicitly ask it not to). If
you have a scheduled backup regime (as any production database server
should have), it becomes a non issue.

Adam





[Non-text portions of this message have been removed]