[check_postgres] misbehavior in check_bloat ?

Cédric Villemain cedric.villemain at dalibo.com
Wed Aug 12 12:34:14 UTC 2009


Le mercredi 12 août 2009, Greg Sabino Mullane a écrit :
> > I need to set -w "161%" to remove this warning when I expect to put
> > 40 % : round((11-7)*100/11) = 36 is the percentage of the wasted
> > space of the *current* real relation size.
>
> This is expected - the number returned is how big the table is compared
> to the expected size, and not the percent of bloat (perhaps we can
> explain that better in the docs?). In other words, if there is no bloat,
> then the table is 100% of it's expected size. This does make the
> percentage checks a little awkward, but we'd need to examine how it
> would effect the other checks, and how a change to that number would
> affect existing installations that already expect the >100% system.

Ok, I understand, so perhaps just adjust a bit the docs, and we are done.
----
Cédric Villemain
Administrateur de Base de Données
Cel: +33 (0)6 74 15 56 53
http://dalibo.com - http://dalibo.org
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: This is a digitally signed message part.
Url : https://mail.endcrypt.com/pipermail/check_postgres/attachments/20090812/c394431b/attachment.bin 


More information about the Check_postgres mailing list