W dniu 2015-07-08 o 14:50, Dmitry Yemanov [email protected] [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 ==--__ __--==============================--__
