On Wed, 27 May 2009, Tom Lane wrote:
It's an interesting exercise in trying to estimate bloat without groveling through the whole relation
Interesting and an extremely common request. I just added an item to the Vacuum section of the TODO list while you were listing issues and potential solutions here: "Provide more information in order to improve user-side estimates of dead space bloat in relations" links to this thread.
As pointed out upthread, there's a fair number of people who have picked up on this particular query for bloat estimation. It seemed accurate enough for gross maintenance use when I did a quick check of its results before, but those were tables without variable widths, TOAST, etc. This is one of those boring tasks that DBAs really want more monitoring-friendly visibility into.
-- * Greg Smith gsmith@xxxxxxxxxxxxx http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
