Hackers,
I've been tinkering with a number of table bloat checks, and it occurred
to me that the problm is that these are all approximations based on
overall gross statistics, and as such highly inaccurate.
It seems like would could have ANALYZE, while sampling from the table,
also check the amount of dead space per page and use that as an estimate
of the % of dead space overall. We'd still need something else for
indexes, but this seems like it would be a good start.
No?
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com