[check_postgres] bloat check and TOAST
Mark Kirkwood
mark.kirkwood at catalyst.net.nz
Fri Aug 26 01:58:45 UTC 2011
On 15/07/11 05:01, Joshua Berkus wrote:
> 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.
>
Also it is fooled by data types without an = operator (xml is the most
likely one you'd stumble into).
regards
Mark
More information about the Check_postgres
mailing list