|Subject||Re: Fill ratio when doing a restore|
> The reserved space was added toHello Ann,
> reduce that "settling in" cost, but given the size of your
> records, the algorithm produces too much free space and you
> do excessive I/O because pages are only 60% full.
A quick question on this one, is there a reason that it is a 100%/60%
toggle rather than allowing the user to set the percentage?
Most of the time 100% is not ideal (even in the case of the OP, it is
just better than 60%). I just wonder whether maybe say a 95% fill
ratio may be better overall in this case, allowing for a couple of
changes on the same page, but also saving on the wasted free space?