Subject Re: [firebird-support] Re: Gbaked and restored database larger than the original?
Author Tomasz Tyrakowski
W dniu 2015-07-08 o 14:50, Dmitry Yemanov dimitr@...
[firebird-support] wrote:
> 08.07.2015 15:18, Mark Rotteveel wrote:
>
>> Another reason could be restoring with a different page size than the
>> original database.
>
> Or some tables were altered to a longer record format after filling them
> with data. The original database contains records in the old (shorter)
> format while the restored database contains records in the new (longer)
> format. Sometimes record-level compression compensates that difference,
> but not always.

That's an interesting insight. I took a closer look at the actual
metadata changes I mentioned in my first post. Apart from a few fields,
which got assigned default values, there doesn't seem to be anything
that could affect database size after restore. No field size changes at all.
But thanks for this suggestion anyway, it's worth remebmering that
changing the type doesn't affect the data that's already there.

regards
Tomasz

--
__--==============================--__
__--== Tomasz Tyrakowski ==--__
__--== SOL-SYSTEM ==--__
__--== http://www.sol-system.pl ==--__
__--==============================--__