Subject | Re: [firebird-support] Re: Gbaked and restored database larger than the original? |
---|---|
Author | Tomasz Tyrakowski |
Post date | 2015-07-08T11:22:11Z |
W dniu 2015-07-08 o 14:50, Dmitry Yemanov dimitr@...
[firebird-support] wrote:
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 ==--__
__--==============================--__
[firebird-support] wrote:
> 08.07.2015 15:18, Mark Rotteveel wrote:That's an interesting insight. I took a closer look at the actual
>
>> 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.
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 ==--__
__--==============================--__