On 09/21/2011 11:20 AM, Venkat Balaji wrote:
It is very important to remove it from the WIKI page.
Removing it is a little premature. :) Definitely going to add a warning about relying on its output, though. The query itself was created and integrated into the check_postgres.pl nagios plugin as a very, very gross estimate of bloated tables.
It wasn't the most accurate thing in the world, but considering what it had to work with, it did a pretty good job. Generally CLUSTER or VACUUM FULL would remove a table from the query output, but not always. It's those edge cases that cause problems.
-- Shaun Thomas OptionsHouse | 141 W. Jackson Blvd. | Suite 800 | Chicago IL, 60604 312-676-8870 sthomas@xxxxxxxxx ______________________________________________ See http://www.peak6.com/email-disclaimer/ for terms and conditions related to this email -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
