On 24.01.25 15:41, Frédéric Yhuel wrote:
On 1/24/25 14:58, Laurenz Albe wrote:
On Fri, 2025-01-24 at 13:34 +0000, Bertrand Drouvot wrote:
+ Since indexes have a default fillfactor of 90, this should be
around 0.9 for
+ newly built indexes
I think 0.9 should be replaced by 90 (that's the actual kind of
output we'd get).
Damn! I missed that one too...
But having said that, I'm not sure we should mention those 90 stuff
because it
depends of the amount of data indexed (I mean if the index has a very
few
leaf pages, say < 5, then it's easy to be << 90 since it's an
average). That's
probably not the majority of indexes though so maybe just nuance the
sentence a
bit.
Sorry about the 0.9.
Perhaps the wording could be more careful: ... this should be around
90 for
most newly built indexes of non-neglectable size.
It looks good to me (apart from the typo). v4 attached
committed
