Subject Re: Size of backup file
Author Aage Johansen
I wrote:
>> I have a database of about 1GB. Doing a backup (with gbak) creates a file
>> of just about the same size. The difference between the gdb and the gbk
>> is less than 30MB, whereas I often see that the gbk is just half the
size of
>> the gdb.
>> The gbk file restores without problems.
>> Anyone else experienced this? Should I worry?


C. asked:

>Do you have blobs?

Yes, but it also happened before blobs were introduced. I think there is
only one blob defined, and that one was introduced rather recently.


>Have you altered the default fill factor of your db?

No. Only page size and cache pages have changed.


>Did you try a backup in non-transportable format to see what happens?

I will. I'll try this on Monday (at work).
I have observed this for quite som time. I even posted a question like
this a long time ago (on the MERS list) - I don't think there was a single
response. (it might have been at a time where more serious matters were afoot).
As it seems to be harmless, I've just ignored it.


Regards,
Aage J.