Subject why the data pages did increase after a backup-restore?
Author emb_blaster
Hi all.

I did a backup-restore, and later a diff in gstat -h of the two files (see part of it below). I saw that num of Data pages have grow after a backup-restore. O.O
The average fill have increased as expected, but I don't understand this increase in dataPages.

I was expecting that this should be always less or equals the number before of backup-restore, because I thought that by organizing and using better the pages (with a greater fill).
I can understand that before the backup-restore it was, lets say in example, 10554 pages with a fill of ~74% and now theres 10702 with fill of ~70%. But still can't see *why* this.
This can be 'cause theres some rows with length greater than 19% of a page? (theres no blob fields and no [var]char greater than 100)
Where I'm wrong?

TIA
Wish all you well,

PS.: Theres 419001 records in this table, and it is a FB2.0 database.

****before*******
TABLEONE (160)
Primary pointer page: 274, Index root page: 275
Data pages: 10585, data page slots: 10585, average fill: 76%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 10554
80 - 99% = 31

***** after *****
TABLEONE (160)
Primary pointer page: 275, Index root page: 276
Data pages: 11008, data page slots: 11008, average fill: 77%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 10702 (148)
80 - 99% = 306 (275)