Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> writes: > Tom Lane wrote: >> It's an interesting exercise in trying to estimate bloat without >> groveling through the whole relation, but I seriously doubt you could >> ever get numbers this way that are trustworthy enough to drive >> maintenance decisions. > Well, pg_stattuple is way too expensive to be running every minute ... Agreed. I was idly wondering whether it'd be useful to have an option in pg_stattuple to sample some small fraction of the pages in a relation, rather than exhaustively examining each one. It'd be subject to all the normal ills of sampling, of course, but I'd still trust it way more than this view. (Especially noting that the view is already dependent on sampling anyway, since it's looking at pg_stats...) regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
