"Pavel Cisar"" <pcisar@...> wrote:

>
> No, reserve is 20%.

As far as I remember Ann's explanations, it depends on a variety of things
(avg record length and something else).

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

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


Dmitry