Subject | Re: Shrink a DB |
---|---|
Author | Svein Erling Tysvær |
Post date | 2005-12-13T15:14:23Z |
--- In firebird-support@yahoogroups.com, "Marcelo" wrote:
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
>Hmm, if you'd said the database didn't shrink it would have been as
> 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.
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