[check_postgres] action bloat provide wrong info

[Greg Sabino Mullane]

> I have some issues with some identified tables.
> One special thing is that the table is using datatype 'point' and there is
> nothing about this column in pg_stats, there is also some varchar with bad
> correlation (so perhaps a totally wrong avg_width ?)

I can check into the point problem. As far as the varchar, that is always going
to be a problem. One thing to try is boosting default_statistics_target (the
default of 10 is insane, of course), re-running analyze on the table, and seeing
if that helps things out a bit.

-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 226 bytes
Desc: OpenPGP digital signature
Url : https://mail.endcrypt.com/pipermail/check_postgres/attachments/20090428/3c8ba120/attachment.bin