Subject | Re: [firebird-support] database growing too much after bulk import |
---|---|
Author | Ann W. Harrison |
Post date | 2008-11-05T17:39:08Z |
Sergio H. Gonzalez wrote:
gstat -a -r >SpaceUsed.txt
Cheers,
Ann
>...
> I have this database:
> ...
>
>
> It has 8,186 KB with some tables filled with some records. After I do an import
> from a DBF table (38.000 records) into this particular table:
>
>The gstat utility will explain space utilization in your database.
> The database grows to 190,416 Kb !!
> Is that normal? The DBF I'm importing it's 10 MB, Of course I know that the
> relation between the DBF size and the growing on my databse may have very little
> to do, but I'm very surprised by the new size my DB gets after the import !.
>
> Just in case: After the import I'm doing a backup/restore to make sure there's
> no non used space in my DB.
>
gstat -a -r >SpaceUsed.txt
Cheers,
Ann