[check_postgres] action bloat provide wrong info

[Joshua Tolley]

On Tue, Apr 28, 2009 at 06:48:29AM -0400, Greg Sabino Mullane wrote:
> > 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.

Point types won't have statistics, because it has neither an explicit
analyze function nor a default b-tree operator class:

5432 josh at josh*# select oid, typanalyze from pg_type where typname =
'point';
 oid | typanalyze 
 -----+------------
 600 | -
(1 row)

5432 josh at josh*# select * from pg_opclass where opcintype = 600;
 opcmethod | opcname | opcnamespace | opcowner | opcfamily | opcintype
 | opcdefault | opckeytype 
 -----------+---------+--------------+----------+-----------+-----------+------------+------------
(0 rows)

-- 
Josh Tolley  josh at endpoint.com  801-485-0203
End Point Corporation

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: Digital signature
Url : https://mail.endcrypt.com/pipermail/check_postgres/attachments/20090428/1e48cc17/attachment.bin