[check_postgres] bloat check and TOAST

[Joshua Berkus]

Ken,

> Does the bloat check in the current version take TOAST tables into
> account? I tried looking at the SQL in the check_bloat function and
> I was not able to easily deduce if it did.

No.  It also ignores page free space, byte alignment, and several other factors.  For indexes, it's unable to take btree depth into account.

You shouldn't be setting anything more severe than an warning off the bloat check ... and then only at 200% + 100MB, or something equally generous.

--Josh