[check_postgres] action bloat provide wrong info

[Cédric Villemain]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Greg Sabino Mullane a écrit :
>> 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.
> 
unfortunely not, at 1000 nothing change, and I think one of the main issue is
the 'point' : it took at least 16 bytes. but this value can not appear in *the*
sql query used by the action.

We must determine every column by table, take the avg_width from pg_stats *or*
take the typlen in pg_type, isn't it ?




- --
Cédric Villemain
Administrateur de Base de Données
Cel: +33 (0)6 74 15 56 53
http://dalibo.com - http://dalibo.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAkn28GoACgkQo/dppWjpEvynlACfdjvoVJ5v6wAjT8gAup09yx2z
8q4AoIZeFx4LJDyNOe+9y4MhKiJp7Z9Z
=xTi+
-----END PGP SIGNATURE-----