Hello, Dmitry!

Tuesday, October 5, 2004, 3:18:23 PM, you wrote:

>> If there is any difference from average 80% fill
>> ratio, then it's caused by data change pattern. Engine always do its best
>> to keep 80% fill ratio. Take a gstat look at freshly restored database.

DY> Avg fill ratio is 53-85% on a freshly restored real database.
DY> 65% of tables have avg fill ratio less than 80%.
DY> 30% of tables have avg fill ratio less than 70%.

And tables with record size ~12 bytes have avg fill ratio less than
60% after restore (worse than any other tables), independently of
database page size (tested).

--
Dmitri Kouzmenko