Subject Re: Shrink a DB
Author Svein Erling Tysvær
--- In firebird-support@yahoogroups.com, "Marcelo" wrote:
>
> Hi All!
> Is there any way or utility to shrink an Interbase DB. I added a lot
> of blobs and big tables, but then they were deleted, but the .gdb kept
> growing.

Hmm, if you'd said the database didn't shrink it would have been as
expected - Firebird reuses the space for future records, without ever
giving anything back to the file system. But "kept growing" makes me
wonder whether there is one or more old, uncommitted transaction(s)
somewhere. Unless you take care of your transactions, your databases
has to keep all versions of every record, and that is never what you want.

Set