>
> 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)
>