Subject | Re: [firebird-support] Gbaked and restored database larger than the original? |
---|---|
Author | Tomasz Tyrakowski |
Post date | 2015-07-08T10:51:20Z |
On 2015-07-08 o 14:14, Svein Erling Tysvær
svein.erling.tysvaer@... [firebird-support] wrote:
apply to my case (I didn't switch to a different version of FB).
-use_all_space, the database size is 94445568 bytes.
Thanks a lot Svein.
regards
Tomasz
svein.erling.tysvaer@... [firebird-support] wrote:
> Take a look here: http://www.firebirdfaq.org/faq361/Yes, I've come across this on another occasion, but it doesn't seem to
apply to my case (I didn't switch to a different version of FB).
> I'd add that restore also has a -use_all_space option. If you don't specify this, then pages are filled to approximately 80% (80% is preferable over 100% unless it is a read-only database). See http://www.firebirdsql.org/manual/gbak-cmdline.html or http://www.firebirdsql.org/manual/gfix-pagespace.html for more information.And that's most probably the bull's eye! After restoring with
-use_all_space, the database size is 94445568 bytes.
Thanks a lot Svein.
regards
Tomasz