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). > > 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. Yours, Laurenz Albe
