[check_postgres] bloat check and TOAST
Joshua Berkus
josh at agliodbs.com
Thu Jul 14 17:01:24 UTC 2011
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
More information about the Check_postgres
mailing list